Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running Excel VBA in an Access module 1
- Thread starter BChumie
- Start date
-
1
- #2
Sure, just open up Excel and tell it to run your macro
Dim tmpApp As New Excel.Application
tmpApp.Workbooks.Open FileName:="FileName", ReadOnly:=False, ignorereadonlyrecommended:=True
tmpApp.visible = True
tmpApp.Run "MacroName"
tmpApp.Close
Set tmpApp = Nothing Kyle![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
Dim tmpApp As New Excel.Application
tmpApp.Workbooks.Open FileName:="FileName", ReadOnly:=False, ignorereadonlyrecommended:=True
tmpApp.visible = True
tmpApp.Run "MacroName"
tmpApp.Close
Set tmpApp = Nothing Kyle
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
