>Mine is 97 SR-1 as well. Glad you got it to work but this still concerns me a little bit. I have an app that automates excel that uses oExcel=createobject("Excel.Application") and this has worked on my machine and on the 2 users I have installed it on so far but, based on what's happened for you, I'm now wary it might fail for a user at some point. Are you using VFP3, 5 or 6? I'm using 6.
I have both 5 and 6, same problem in each. I suspect something is wrong with my Excel OLE setup, but I haven't the faintest idea what to look for. My Excel has had no problems, using it directly...beats me what's wrong, I'm hoping a UTer will have seen this before...
I imagine the alternative code I posted is a safe bet, since it's been in Solutions for awhile, but who knows? I'll have to test that more, too...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.