Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Active X
Message
From
13/12/1999 16:50:39
Todd Brown
Teachers Credit Union
Granger, Indiana, United States
 
 
To
13/12/1999 16:00:54
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Miscellaneous
Thread ID:
00302848
Message ID:
00302989
Views:
29
Thanks for the response. In my code I have made excel visible by the command you described (mvFile.Application.Visible = .T.). What I am having trouble with is when opening the spreadsheet in excel, the spreadsheet is hidden. Excel is visible, however to see the spreadsheet you have to go to Window Unhide. I believe I am missing a crucial link between the ActiveX code in VFP and the visual basic code in Excel. I record a macro in Excel and the code will not work under ActiveX VFP.

For example to open a file in Excel returns
Workbooks.Open FileName:="C:\data\Bud00\FS.xls"
ActiveWorkbook.Close
However, when I run this code in VFP
oSheet = CreateObject("Excel.Sheet")
oSheet.Application.Visible=.T.
oSheet.Workbooks.Open FileName:="C:\data\Bud00\FS.xls"
OR
oSheet.Workbooks.Open ("C:\data\Bud00\FS.xls")
I get error messages.

Any suggestions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform