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.