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!
-
How to close Excel from Access using VBA?
..darnit.. The only reason my code was working was because I was breaking out of the program rather than allowing it to run through, obviously when I stopped it any processes it has spawned are automatically quit. I have been battling with this for 2 days now and it's causing me problems. If...- rusty666
- Post #22
- Forum: Bar coding and automation
-
How to close Excel from Access using VBA?
Hi, I notice in most of these solutions you are defining a new excel object, then opening a workbook. This actually spwans another instance of excel within itself which cannot be closed easily. If you don't create a new instance initially it seems to work better. Here is some code that works...- rusty666
- Post #21
- Forum: Bar coding and automation
