Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open an Excell spreadsheet in FoxPro
Message
From
12/05/2000 14:46:15
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00369166
Message ID:
00369190
Views:
20
Great thanks,

I'm not familiar with createobject and OLE. I try the code and it work but why is the last line saying objExcel.Visible = .t. and not objBook.Visible = .t. ?


Second question:
I want to add this code to a command button. Should I put everything under click() or do something like this:

excelbut.init()
objExcel= CREATEOBJECT("Excel.Application")
lcFile = "C:\SourceVam\Special Clients\RessortCharland\transfertStock\Info.xls"
objBook = objExcel.WorkBooks.Open(lcFile)

exccelbut.click()
objExcel.Visible = .t.


What would be the impact on memory usage and speed?

Thanks.
Diane Robitaille eng.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform