Open xlsx during program execution

Topics: User Forum
Jan 23, 2007 at 12:02 PM
I wrote a simple program in Visual Basic 2005 which creates a simple xlsx file.
My problem is that Excel doesn't recognize the file until I close my program. After I have closed my program, the created file is perfectly readable.
What can I do to open the file in Excel, during the execution of my program?
Jan 25, 2007 at 1:04 AM
VB.NET does not have the "using" keyword which automatically calls Dispose() for you when the varible goes out of scope. So you will need to call Dispose() on the package and that will release the handle.
Jan 28, 2007 at 9:19 PM
Thank you very much for your help.
Feb 16, 2007 at 10:48 AM
VB.NET has Using keyword and it works the same.