efficiently open and close an Excel file in VBA Access

I'm writing a code in vba Access 2002 a button to open an Excel file do some work and close it and it works but if you refresh and clik again the button get an error "object variable or with block not defined" In the Task Manager from Windows I see the Excel process running even if the file is close....the code vba did not kill the process when exiting the code, so I have to close the application and re-start.

How can I close the file and kill the process in order to open Excel files without exiting the application?

Thank you

This is part of the button code:

Please Login or Register  to view this content.

Can you add code tags?

The first thing you should be doing in the code is creating a reference to the workbook you are opening, when you open it.

You would then use that to reference the workbook throughout the rest of the code.

One thing you definitely shouldn't be doing is using ActiveCell, that doesn't really mean anything in Access VBA and could actually be connected to the problem you describe.

This is how I would do the code.

Please Login or Register  to view this content.

Note I've used oWs.Range("A1") in place of ActiveCell as I assume you want to refer to A1 on 'Feuil1', obviously change that if that assumption is incorrect.

Is that all you changed in your original code?

That might not be a good idea, oExcel is a reference to the Excel application not the workbook.

Try using explicit references to the workbook/worksheet/range.

That's what you would do if the code was being run in Excel.