macros to open excel spreadsheet and control

  • Thread starter Thread starter STRYKTERRY
  • Start date Start date
S

STRYKTERRY

I am trying to use a button from an Access form with the use of a macros to
open an Excel spreadsheet and automatically open the Find control
simultaniously. Can anyone shed some light on this?
 
Watch for word wrap

Create a macro(FindInfo) in the Excel file with the find
action.

In an Access macro
Action: RunApp

Command Line:
"C:\PathToAccess\MsExcel.exe" "C:\PathTofile\YourFile.xls"
"macro name"

example
"c:\program files\microsoft office\office\Excel.exe"
"c:\my documents\test1.xls" "findInfo"

Jim
 
Back
Top