open Excel doesn't stay open
Hi all,
I have code to open my Excel sheet, but it only opens for a second, how do I get it to stay open to view the data??? this is Vb.net
THanks so much
Dim xlsApp As Excel.Application
Dim xlsWB As Excel.Workbook
Dim xlsSheet As Excel.Worksheet
xlsApp = New Excel.Application
xlsApp.Visible = True
xlsWB = xlsApp.Workbooks.Open("C:\Temp\Stuff.xls")
Re: open Excel doesn't stay open
Is it ok when you manually open your Stuff.xls workbook? Do you have any other code that may be interferring?
Re: open Excel doesn't stay open
HMMMM. good question. I did check the file while my application was running and manually it did say that it was "Read only", where I clicked OK. This excel sheet is being created by the application in question, I just want the user to be able to look at the current results. I do close the Excel file in code before I try to open it, but maybe it is still locked. There must be a way to see a new file during the running of the application???? maybe I expect tooo much.