How do I open an Excel Spreadsheet from Access

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

Guest

I simply want to open an existing Excel spreadsheet from within Access. I
will create a button on a form that executes the process, I just ned to know
how to access and open the spreadsheet.
Any help would be appreciated.
Thank you.
 
Create a command button with the Wizard box checked. A Commnad Button Wizard
dialog box opens; under Categories, select Applications; under Actions,
select Run Application.

Follow instruction in Wizard dialog box. Example would be: "Excel.exe
<space> Path and filename" of Excel doc you want to open. Finish the
remainder of the Wizard and you're all set.
 

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

Excel Excel spreadsheets opening at top instead of bottom. 4
Excel shortcut options 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Data Transfer Issue (strange situation) 1
Excel Spreadsheets keep moving 0
Access VBA creating an Excel spreadsheet with a total line 5
Open a specific Excel spreadsheet within an Access DB Form 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4

Back
Top