Running VBA script file from excel macro

Question

I'm trying to run a vbscript file from excel macro, can anyone please help.

Dim sFilename As String
sFilename = ActiveWorkbook.Path & "C:\Users\266720\AppData\Roaming\SAP\SAP GUI\Scripts\Script7-pa30.vbs"
sFilename.Run

Currently, sFilename will look like c:\foo\bar\c:\Users\266... You are concatening two absolute paths — litelite
– litelite, Commented May 11, 2016 at 13:14

rook · Accepted Answer · 2016-05-11 13:09:20Z

-1

Could be an issue with the space in your reference.

"C:\Users\266720\AppData\Roaming\SAP\SAP GUI\Scripts\Script7-pa30.vbs"

I would change the folder name to SAP_GUI and see how that works, or use double quotes around the whole line.

"""C:\Users\266720\AppData\Roaming\SAP\SAP GUI" & "\Scripts\Script7-pa30.vbs"""

rook

6,3305 gold badges42 silver badges54 bronze badges

answered May 11, 2016 at 13:07

timthebomb

2302 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Windows manage spaces in paths. And this is not sent to a shell so a space should not matter