Problem with Excel Addins

[ThunderTek]

Here is my code line:
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


I am attempting to automate open Excel from Access, but in order for Excel
to do what I need....I have to install an addin. The problem that I am
getting is that the addin is opening another instance of Excel. After Excel
is opened and the addin installed, I then need to calculate the data on Excel
and import the data into Access. I would like this to happen without any
user input. Is this task even possible?

 

[Harlan Grove]

I am attempting to automate open Excel from Access, but in order for Excel
to do what I need....I have to install an addin. The problem that I am
getting is that the addin is opening another instance of Excel. After
Excel
is opened and the addin installed, I then need to calculate the data on
Excel
and import the data into Access. I would like this to happen without any
user input. Is this task even possible?

*.office.misc is most definitely not the right newsgroup for this question.
Use the Excel programming newsgroup.