If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with Excel Addins
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? |
#2
|
|||
|
|||
Problem with Excel Addins
"ThunderTek" wrote...
.... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange Excel Problem..... | Sachin Shah | General Discussion | 0 | November 14th, 2005 09:36 AM |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Excel selection problem | peakscan | General Discussion | 0 | November 4th, 2004 05:49 PM |
Excel 2000 & pivot tables problem | fpp | Worksheet Functions | 3 | September 10th, 2004 06:27 AM |