Thread: how to call Access function&module in Excel VBA??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default how to call Access function&module in Excel VBA??
Your code works for me adding quotes around the macro
name, i.e.: ac.Run "test1"

I'd recommend adding the following afterwards:
ac.CloseCurrentDatabase
ac.Quit

HTH,
Merjet



Reply With QuoteReply With Quote