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