Open Excel file with button on form

  • Thread starter Thread starter Anders
  • Start date Start date
A

Anders

Hi,

I would like to add a button to a form in Access 2003,
that opens a specific Excel file.

I have found the wizard that lets me open the Excel-
application -- but I cannot figure out how to specify
exactly which file to open.

Note: I do not want to export any data form Access to
Excel -- I just want to have a button that opens a
specific Excel file that already exists.

Any ideas?

Many thanks,
Anders Sjöman
 
If you don't want to do anything progamatically with the Excel file: -
Just use the hyperlink property of the button on the properties page,

Cheers,
Peter
 
You can start any app that has an associated program with ShellExceute:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi,

I would like to add a button to a form in Access 2003,
that opens a specific Excel file.

I have found the wizard that lets me open the Excel-
application -- but I cannot figure out how to specify
exactly which file to open.

Note: I do not want to export any data form Access to
Excel -- I just want to have a button that opens a
specific Excel file that already exists.

Any ideas?

Many thanks,
Anders Sjöman
 
Back
Top