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?
I've solved it in another way. Silly of me not discover that solution earlier. I just did the sort in Access, before exporting it to Excel as pivot table. So now everything is just perfect. It's seems like using the Xl object creates another instance of Excel, so when you close it you're not...- pser
- Post #6
- Forum: Bar coding and automation
-
How to close Excel from Access using VBA?
I've think i've solved my problem now. It's seems like a matter of using the right command for doing the right thing or else it creates another instance of the object, so at the end when you close it you're not able to close the second instance. One thing i haven't solved it to sort the...- pser
- Post #5
- Forum: Bar coding and automation
-
How to close Excel from Access using VBA?
I have the same problem. I think one solution could be to find the windows handle with the following API and then close that handle. Right after you create the Excel object you do this: hWndXl = FindWindow("XLMAIN", AppExcel.Caption) Then you get the handle and it just matter of...- pser
- Post #3
- Forum: Bar coding and automation
