open an excel file

C

Carlos

How can I open an excel file from Access?

What is the code syntax?

Thanks in advance
 
J

Jim/Chris

Create a macro
Action: RunApp
Command Line: c:\program files\microsoft
office\office\Excel.exe "c:\my documents\test1.xls"

Watch out for word wrap

Jim
 
G

Guest

Hi Jim

is it possible to assign a variable/ value of a textbox to commandline of the RunApp macro

Thanks
yann
 

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

Excell 2021 0
Excel Unlink open excel files 2
Open .xlsx files in Excel 2002 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Open an Excel file using macro 2
Browse button for access form 1
Excel How to activate already opend PDF file through VBA code 1
Open Excel from Access no *.xla 1

Top