Call/execute an Excel macro from Access retrieve result back to Access 1

[JoeVegas]

Will someone please provide me with a vba code example of calling/executing from Access, a macro in Excel and retrieving the result back to Access. I have been able to use the DoCmd import excel worksheet into Access and creating a new table but I need to import the data into an existing related table. Example: In Access call/exceute the macro in Excel, import the produced/formatted data into an existing related table in Access. I am using MS Office 2003. Thank you all in advance.

 

[PHV]

Have a look to the Excel.Application.Run method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeVegas]

PH, I tried to examine the (Excel.Application.Run method) in Access and Excel help but couldn't find it.

 

[cheerio]

In Excel go to a code window (Alt F11) and select the Object browser.

Change the library dropdown to Excel and in the lower window click on application. To the right you will see Run. Right click on Run and select Help.