Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Closing Excel from Access VBA Module
The code I am using is as follows: Dim myApp as Excel.Application set myApp = new Excel.Application myApp.Visible=True //so I can see it close ...code to read in some data Then, I have tried the following, none of which work to remove the Excel process from memory... 1. myApp.quit (or...- maranello
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Closing Excel from Access VBA Module
Hello everyone... I am having a problem closeing an instance of Excel from within an Access VBA module. The window disappears, but the Excel process does not. Could someone tell me the correct way to do this?- maranello
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access Controling Excel
I am accessing an Excel spreadsheet from within an Access VB Module. When I close Excel using 'myApp.Application.quit', or any of the various other functions which are supposed to work, there are some instances where the Excel window disappears but the Excel process does not. Does anyone know...- maranello
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
