macros to open excel spreadsheet and control

[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?

 

[Jim/Chris]

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