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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel remains in memory even after application ends.
Thanks Tom. I tried the method you suggested but it did not work for me. Is it because I am using Access 97 instead of Access 2000? Regards, dynasty- dynasty
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Excel remains in memory even after application ends.
Hi, I created an Excel application within Access 97. However, the Excel still remains in the memory after running the following code. This causes Excel sheet(s) not visible if I open another Excel file. Could anybody help? Thanks in advance. dynasty -------------------------------------------...- dynasty
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to close Excel from Access using VBA?
Dear all, I had the same problem and tried all your suggestions but did not work. Now I found the solution and am glad to share it with you all: Const ERR_APP_NOTRUNNING As Long = 429 On Error Resume Next Set xlApp = GetObject(, "Excel.Application") If Err =...- dynasty
- Post #7
- Forum: Bar coding and automation
