How to quit an Excel process from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help, desperate

i have code that will open and close an Excel file. I can tell it works
correctly because I watch the processes and make sure the Excel disappears.
My problem is when i am using an Access table that is linked to this Excel
file. If I open this file anytime that the original Excel file is opened, I
cannot exit my Excel processes. I have tried watching step by step through
the code. I start by opening MyExcel.xls then I will open the Access Table,
which has been imported and linked to some of the cells in MyExcel.xls. When
the code goes to Quit and Set wk and exl to Nothing, the MyExcel.xls process
closes however another Excel process remains open. I think this is because
there is still a connection between my Linked Access Table and a second
instance of MyExcel.xls. How exit the Excel process?

Thanks,
Matt
 
Look at the option of importing the data instead of linking to it. Both
methods have their advantages as well as disadvantages.
 
Back
Top