View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sean McPoland[_4_] Sean McPoland[_4_] is offline
external usenet poster
 
Posts: 1
Default Launch Excel vba macro from Access?

This is how I do it from powerpoint - should work in
Access as well.

regards
Sean



Sub Main()

Dim appXL As Excel.Application
Set appXL = New Excel.Application
appXL.Visible = True

appXL.Workbooks.Open "D:\???\xxx\fn.xls"
appXL.Run ("sDriver") ' run the excel macro

appXL.ActiveWorkbook.Save
appXL.Quit

ActivePresentation.Save
Application.Quit

End Sub