Can't get excel to close from task manager

T

ThunderTek

Excel will not close. I have to load an Add-In, open a workbook, transfer
data into Access, close and save excel.....all without the user knowing that
excel even opened. Here is my code: (I need to get excel to dump off and I
need an autosave line before closing the excel sheet.) I also get an error
message for an ActiveX control that I do not use......please help.

Dim objXL As Object
Set objXL = CreateObject("Excel.Application")

objXL.Workbooks.Open (objXL.LibraryPath & "\AtData.XLA") '.RunAutoMacros 1
objXL.Workbooks.Open "C:\AlkyLabData.xls"
objXL.Visible = False
DoCmd.TransferSpreadsheet , , "TestingImportData2", "C:\AlkyLabData.xls", True

Me.Requery
DoCmd.GoToRecord , , acLast
objXL.Quit
Set objXL = Nothing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Excel Addins 1
TransferSpreadsheet in Access (Excel Not Closing) 5
Excel Automation? 6
Closing Excell from Access 3
TransferSpreadsheet leaves Excel.exe in memory 7
Getting values from Excel worksheet 4
Working with Excel objects from Access 2
Excel: A document with the name is already open 2

Top