AnsweredAssumed Answered

vrf Excel Problem????

Question asked by VRFuser on Jan 11, 2008
Thank you all for your input.

 

Doug Parrish

 

Test Engineer

Comtech PST

105 Baylis Rd

Melville, NY 11747

631.486.4126 (Direct)

631.777.8900 x 126

HYPERLINK "mailto:doug.parrish@comtechpst.com"doug.parrish@comtechpst.com

 

 

  _____  

From: Voltz, Gary [mailto:gary.voltz@AirservicesAustralia.com]
Sent: Thursday, January 10, 2008 4:49 PM
To: VRF
Subject: RE: [vrf] Excel Problem????

 

If that is the cause, the trick is to make that sheet the active sheet immediately before the insert operation.  I usually turn screenupdating off, so users don’t see all the sheet changes, and when finished, turn screen updating on.  Although I’ve never tried to see if the user can interfere when screenupdating is off, it would be interesting to see what happens.

 

Just got diverted by a train of my own thoughts and delved into Excel and found the following in Excel’s Help.


Interactive Property


See AlsoApplies ToHYPERLINK "mk:@MSITStore:C:Program%20FilesMicrosoft%20OfficeOFFICE111033VBAXL10.CHM::/html/xlproInteractive1.htm#example#example"ExampleSpecifics

True if Microsoft Excel is in interactive mode; this property is usually True. If you set the this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Blocking user input will prevent the user from interfering with the macro as it moves or activates Microsoft Excel objects. Read/write Boolean.


Remarks


This property is useful if you're using DDE or OLE Automation to communicate with Microsoft Excel from another application.

If you set this property to False, don't forget to set it back to True. Microsoft Excel won't automatically set this property back to True when your macro stops running.


Example


This example sets the Interactive property to False while it's using DDE in Windows and then sets this property back to True when it's finished. This prevents the user from interfering with the macro.

Application.Interactive = False
Application.DisplayAlerts = False
channelNumber = Application.DDEInitiate( _
    app:="WinWord", _
    topic:="C:WINWORDFORMLETR.DOC")
Application.DDEExecute channelNumber, "[FILEPRINT]"
Application.DDETerminate channelNumber
Application.DisplayAlerts = True
Application.Interactive = True

 

Cheers,

Gary

Gary Voltz
SASTO4

Test Equipment and Maintenance and Calibration Centre

Facilities Management Services

Technology and Asset Services

Airservices Australia


E-mail: gary.voltz@airservicesaustralia.com

  _____  

Airservices Australia
Ph 1300 301 120       (within Australia)
Ph +61 7 3866 3382  (outside Australia) 
Fax +61 7 3866 3531
HYPERLINK "http://www.airservicesaustralia.com/"www.airservicesaustralia.com

CAUTION: This e-mail is confidential. If you are not the intended
recipient, you must not disclose or use the information contained
in it. If you have received this e-mail in error, please tell us
immediately by return e-mail and delete the document.

Airservices Australia does not represent, warrant or guarantee
that the integrity of this communication is free of errors, virus
or interference.

 

  _____  

From: Charles.Stewart@vertu.com [mailto:Charles.Stewart@vertu.com]
Sent: Friday, 11 January 2008 2:02 AM
To: VRF
Subject: RE: [vrf] Excel Problem????

 

Hello folks:

 

I Get this some times when using a multisheet excel work sheet and I'm on the wrong sheet. (IE Excel is trying to write to a sheet other then the one that's open.)

It's usually my fault for looking at results when a test is running.

 

Or if I open another sheet.

 

Hope this helps

 

 

 

 

 

  _____  

From: ext Esbach, Brandon [mailto:Esbachb@tycoelectronics.com]
Sent: Thu 10/01/2008 15:54
To: VRF
Subject: RE: [vrf] Excel Problem????

First response from Google:

http://support.microsoft.com/kb/828550

 

"You receive run-time error 429 when you automate Office applications" is the title

 

< aaaargggghh there goes the Out-Of-Office Storm Cloud Generator >

 

  _____  

From: Doug Parrish [mailto:doug.parrish@comtechpst.com]
Sent: 10 January 2008 15:05
To: VRF
Subject: [vrf] Excel Problem????

Hi VRFr’s,

          I am getting an error with the following description:

 

Runtime Error 429: ActiveX component cannot create object

 

This seems to be related to taking a screenshot from an E4407 spectrum analyzer and then inserting it into excel.  It is an elusive problem that happens intermittently and I do not have access to the machine where it is occurring.  Can anyone tell me what this error means?  I suspect one of the following….

 

1.      The filename of the screenshot to insert is incorrect/never created from spectrum analyzer.

2.      The sheetname to insert the screenshot into is incorrect.

3   Excel is closed when trying to insert the file.

 

Thanks in advance,

 

Doug Parrish

 

Test Engineer

Comtech PST

105 Baylis Rd

Melville, NY 11747

631.486.4126 (Direct)

631.777.8900 x 126

HYPERLINK "mailto:doug.parrish@comtechpst.com"doug.parrish@comtechpst.com

  


---
You are currently subscribed to vrf as: Esbachb@tycoelectronics.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: Charles.Stewart@vertu.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: gary.voltz@airservicesaustralia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: doug.parrish@comtechpst.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes