Recent content by SAGulick

Thanks for all the help...Access MVP's/Gurus.

Pleeeeease...anybody...lol.

Try: 'Repairs and compacts DB CommandBars("Menu Bar").Controls("Tools").Controls("Database utilities").Controls("Compact and repair database...").accDoDefaultAction

Yes, the code does make it through killing the app object...it just doesn't, REALLY kill it...all the way.

One more thing. If I end the task, Excel.exe in the Task Mgr, and rerun the code, I get this err msg (The remote server machine does not exist or is not available). If I just rerun my code, I get this err msg (Method ‘Sheets’ of object ‘_Global’ failed).

If you're asking if it's a runtime error, yes it is. To the user, the code seems to run fine, because the Excel window will close. The problem is, is that even tho Excel closed, there is an instance of Excel in the Task Manager processes. With that said, my code will crash, the next time the...

The only way it clears in the Task Mgr is if I close Access.

I read at the MSDN site that this was a known issue w/Access. Being that I'm pretty new to VBA, I'm not quite sure HOW to fix it with their workaround?

Yeah, but I got a 'Method or data member, not found" error. The class was created by the "Total Access Analyzer" suite.

Yep it's ver 11.0

Refs: Excel 11.0 Obj Lib, Total Visual CodeTools, Total Visual SourceBook

I get a method or data member not found. Should I just try Excel.Quit?

...sorry, I don't get any error msg and it doesn't halt the code.

Yep, that was what I tried the first time, but still had the same problem. You may notuice that I commented out the closing of the excel file. I did that to ensure, when I manually closed the file that it would, in turn, disappear from the Task Mgr processes window...it didn't...lol.

I've been all over this site, as well as others, just trying to find a solution that works for my code, but have had no luck. The last attempt, I used the Total Access Analyzer source code. It worked fine...until I inserted my code in between the start and close of Excel. My code is shown...