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".
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".
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: 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".