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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Quitting excel using access
Hi PH Thanks for the tip, I tried it but it didn't help. It does, make for better code so I appreciate it. I just cannot get excel to quit. I am sure that it is tied up with the transferspreadsheet statement, but I just do not know where in that statement the problem is.- bushman69
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Quitting excel using access
Hi Remou The if statment works fine, but excel does not quit when I am using the transfer spreadsheet docmd. If I comment out the docmd.transferspreadsheet line of code then it all works fine and excel quits. As soon as I reinstate the docmd statement then excel does not quit. I just cannot...- bushman69
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Quitting excel using access
Hi I am trying to find out how to quit excel after importing 2 worksheets from an excel file. I have done a lot of searching on the net, but I cannot seem to solve this problem. I would really appreciate some help. I have isolated it down to the DoCmd.TransferSpreadsheet command. If I comment...- bushman69
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
