Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Installed excel 2010
Message
From
03/02/2012 12:23:23
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01534364
Message ID:
01534412
Views:
35
Sergey:

Thanks, that helped. It's hanging because a dialog is up asking if I want to update refernces to other files. Funny - in 2003, this dialog appeared even though I set visible to .f.. I guess I'll have to figure out how to do this in 2010 OR open the file with some setting that suppresses the question. Any ideas?

Thanks,

Yossi

>Try to set loExcel.VISIBLE = .T.
>Maybe it'll help see the problem
>
>>
>>This code hangs once I installed Excel 2010. BTW, I left Excel 2003 on my computer as well.
>>
>>
>>LOCAL loExcel AS Excel.APPLICATION
>>
>>CLOSE ALL
>>
>>SET PROCEDURE TO sysproc
>>SET DELETED ON
>>
>>CLEAR
>>
>>SUSPEND
>>
>>USE flckmast ORDER flcode
>>
>>loExcel = CREATEOBJECT("Excel.application")
>>loExcel.VISIBLE = .F.
>>
>>loWorkBook = loExcel.Workbooks.OPEN('P:\Flock Information.xls')  &&HANGS HERE
>>
>>
>>Thanks,
>>
>>Yossi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform