Link with MS Excel

[Gilberte Lamoureux]

Hi
I have in a table a text field containing the path of an excel file. Name of
this field is [file]
When a form related to this table is open in simple mode, i can see in the
[file] field someting like c:\Data\Excel\cus001.xls
or for another record I can have something like c:\Data\Excel\ron017.xls
I would like to insert a command button to open excel and also open the file
related to the record
thanks

 

[DanK]

Make the button using the wizard. In the left window,
choose "Application" and in the right window, choose "Run
Application" then type in the path (ie.
C:\Excel\MySpreadsheet).
When the user clicks the button, it will open the program
and the application all at once.