how do i open xls document from access using command button in fo.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i would like to know how to open xl sheet documnet by using command botton
in access form

thank in advanced
 
There are different approaches possible but the easiest would best to simply
use Application.FollowHyperlink

Application.FollowHyperlink "PathandFilename"
Application.FollowHyperlink "C:\temp\test.xls"

If your path is on your form in a textbox named txtXLSFile for example then
youd do something like

Application.FollowHyperlink me.txtXLSFile

For more info lookup FollowHyperlink in the help.
 
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

Opening a sub-form from a command button 1
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Open New Word Document from a Template Using a Command Button 5
Creating Command Buttons On The Fly 1
Access Automatically Send a notification email once a record is added 0
Save and Close command buttons 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Command button to open form in Access 2007 1

Back
Top