Running Shell runtime command with spaces from VBA

Asked Jul 01 '22 at 08:51

Active Jul 01 '22 at 09:01

Viewed 40 times

I'm trying to run the following command in VBA:

Call Shell("C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE Y:\Sales Team\Sales_Price_Database.accde /runtime").

It fails on the space between Sales and Team. Without that space it works fine. How can I make it working with the space between Sales and Team?

edited Jul 01 '22 at 09:01

Kostas K.

asked Jul 01 '22 at 08:51

Michel Verberg

Try `Call Shell("C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE ""Y:\Sales Team\Sales_Price_Database.accde"" /runtime")` as `""` escapes `"`. – Alex K. Jul 01 '22 at 09:05
It works, 1000x thanks Alex!! – Michel Verberg Jul 01 '22 at 09:55

0 Answers0