Afvikle makro i Excel uden at åbne filen

you can try automation.

This is an example which I have NOT tested but should give you an idea.

Public Sub RunExcelMacroOrSub()

'declare variables
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook

'excel application stuff
Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("YourFullFilePathNameHere")

'run the macro
xlApp.Run "YourMacroOrSubNameHere"

'save file
xlBook.Save

'done
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing

End Sub

and you will very likely need a reference to Excel

Der findes forespørgsler og makroer i Access der kan klare jobbet. Men hvad er der galt med OLE (Object Linking and Embedding) og DDE (Dynamic Data Exchange)?

Blev ike aktuelt alligevel