I have an application that allows the user to upload information from and Excel sheet. Since the user is more familiar with Excel, they prefer to do it this way. My software will close the workbook with Me.exApp.Workbooks.Close() , but if you have the task manager running, you can see the Excel application continues. I know the workbook is closed, b/c it asks if you would like to save changes. One instance of Excel will close when the program is exited, but the user normally builds a folder of Excel files and does them all at once. If 8 instances of Excel exist, only one will close with the program.

Any ideas? Anything would help!

Thanks!

Recommended Answers

All 2 Replies

I use:

excel.Workbooks.Close()
         excel.Quit()
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.