View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob Stewart Rob Stewart is offline
external usenet poster
 
Posts: 2
Default Launch Excel vba macro from Access?

Perfect!

Thanks Sean.

"Sean McPoland" wrote:

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