Trigger Excel report from datasheet on click event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, is there an easy way to trigger an Excel report based
on a datasheet form or query? Ideally, this should happen
on a click from the user. Not sure if there is an easy
method for this in VBA?
Thanks
 
Add a command button tied to a macro with a RunApp Action

Action: RunApp

Command Line: "Application location" "file location"
example
"c:\program files\microsoft office\office\excel.exe"
"c:\my documents\test1.exe"

Jim
 
Back
Top