I have an application where some data is stored automatically to Excel. However during the storage of data, the Excel spreadsheet is visible to the user. I need to know if there is any way to make the Excel run at the background.
Thank you.
Printable View
I have an application where some data is stored automatically to Excel. However during the storage of data, the Excel spreadsheet is visible to the user. I need to know if there is any way to make the Excel run at the background.
Thank you.
How are you saving the data?
Excel is basically a large XML file. So, you should be able to write standard XML to it and not have to open the file.
It's been a while since I've had to create an Excel file w/ VB, but the last time I did it, I used the built in .NET methods and never had to open Excel while writing.