Syntax

  • Thread starter Thread starter MikeS
  • Start date Start date
M

MikeS

Can anyone tell me how to use a path that has a space in one of the folder
names, i.e.

PMT = Shell("C:\Program Files\Microsoft Office\Office10\Excel.exe S:\Mal
Lab\DishwasherInspectionChecklist.xls.", 3)

I get an error because of the space between "Mal" and "Lab". It says it
can't find the file "Mal.xls".

Thanks in advance,
MikeS
 
I am no expert on this, but you might try

PMT = Shell("""C:\Program Files\Microsoft Office\Office10\Excel.exe"" ""S:\Mal
Lab\DishwasherInspectionChecklist.xls""", 3)


Note that you also had a period after xls in your posting, so the inclusion of
the double quotes may be totally an error on my part.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top