macro run app access

[Jan Buckley]

I'm trying to open an Excel file from a macro in Access but can't seem to get
the code right. My file name has spaces in it and for every space, Access is
interpretting it as the end of the file and is adding .xls. What is the
correct forma for entering the path?

 

[Steve Schapel]

Jan,

Enclose the path/file name in ""s. Assuming you are using a RunApp
action in your macro, the Command Line argument should look something
like this...

"C:\Program Files\Microsoft Office\Excel.exe" "C:\YourFolder\Jan
Buckley.xls"