I have the program export data to excel file. When export to excel (
its take 5, 6 minutes to finish) .

the code sample he

Dim xlApp As Object
Dim xlBook As Object
Dim xlSheet As Object

Set xlApp = CreateObject("Excel.Application")
'Open Template file, save as temp file
Set xlBook = xlApp.Workbooks.Open(getFileSource)
xlBook.SaveAs tbFilePath.Text

'Open temp file, write data to its
Set xlBook = xlApp.Workbooks.Open(tbFilePath.Text)
.....

If user open other excel file, its will make my excel visible and loss
data and raise error, or if user click close excel windows, its will
close my running excel both :(
I am using excel 2003.
How do the user can open other excel file, edit or close so its not
effect to my running excel file? or how do i create new excel instance
when user open other excel file.
I see the software (Cognos Powerplay) create excel report and its not
be damage when user open other excel file.

Please help me to do that :(

Thanks & regards,

Huy.


--
rauxalacch
------------------------------------------------------------------------
rauxalacch's Profile: http://www.excelforum.com/member.php...o&userid=28300
View this thread: http://www.excelforum.com/showthread...hreadid=478706