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. When I try,
oExcel = GetObject(, "Excel.Application")
oWB=oExcel.ActiveWorkbook
oWB.SaveAs ("C:\zz")
I get messages about oWB not being an object. If I bring up Excel the "normal" way, put some data in it, the 3 lines above work just fine.
Can someone explain what is happening? Can I use Automation in VFP here?
Thanks.
Tim