Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automation of Excel under IE
Message
From
16/11/2004 13:33:13
 
 
To
05/11/2004 11:42:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00958541
Message ID:
00961829
Views:
32
Cetin--


>>My client uses a web site to get some data. When the user asks for the data to be downloaded, a 2nd instance of IE starts with Excel running in it (among other things the Excel menus are different, the menus do not work with the Alt key from the keyboard, etc.). The XLS is sitting on the the web site. Manually the user can save it to the hard drive. If I bring up VFP and put
>>
>>
>>oExcel = GetObject(, "Excel.Application")
>>WAIT WINDOW oExcel.Range ("A1").value
>>
>>
>>in the Command Window, everything is fine.
>>

I went the easy way 2 weeks ago. Since I got the above to work, I brought the contents of the XLS into my VFP program cell by cell (slow and dumb, but it worked) and then did what the client needed done to the data.

We deployed to 20+ machines. Worked great except on 2 machines (all machines are Win XP with IE 6 and Excel 2000). On the 2 machines that fail

oExcel = GetObject(, "Excel.Application")
WAIT WINDOW TYPE ("oExcel.Range")

says that oExcel.Range is undefined (on the other 20 machines it is an object). Any thoughts on what could be going wrong? I have never used Automation on Excel running under IE. Strikes me that life should be different than just using Automation on Excel.

Tim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform