Link with MS Excel

  • Thread starter Thread starter Gilberte Lamoureux
  • Start date Start date
G

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access 4
Open .xlsx files in Excel 2002 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excell 2021 0
Separate Form 0
Excel file extension is camouflaged as xls 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Excel Excel cannot open .xls file 0

Back
Top