XL Macro

[baronvont]

Hi all,

I have a bit of code that exports data from Access to XL. Once there XL VBA code formats the data for me. At the moment I have to fire the macro from XL manually. Is there a command in Access VBA that will run an XL macro

Thanx
Georg

 

[Chance1234]

reference the excel libary

Sub sidneystrangelove()
Dim Xl as Object
Set XL = CreateObject("Excel.Application&quot

XL.Workbooks.Open "C:\temp\yourspreadsheet.xls"

XL.Run "modulename.yourmacro"


End Sub