Make shell wscript variable to the current user

[Razzy]

#Topic: Eksport variable from Excel


This line of code works:

Shell "wscript C:\Users\FR\Documents\Script\BlueBeam\csvconverter.vbs " & myPath & " ", vbNormalFocus

How to get it dynamic to the current user like:

Shell "wscript C:\Users\%username%\Documents\Script\BlueBeam\csvconverter.vbs " & myPath & " ", vbNormalFocus

Do I need to build up the path part by part?

Like:
1 = C:\Users
2 = Application.UserName
3= \Documents\Script\BlueBeam\csvconverter.vbs

newpath = 1 & 2 & 3

I am not yet the most steady person in VBA.

Thx in advance guys!

 

[Akihito Yamashiro]

Yes, you need to build up the part by part.
Or you can get the document path directly like this.

Set wsh = CreateObject("WScript.Shell")
documentsPath = wsh.SpecialFolders("MyDocuments")
Set wsh = Nothing

sPath = documentsPath & "\Script\BlueBeam\csvconverter.vbs"

MsgBox sPath

 

[Razzy]

Yes, you need to build up the part by part.
Or you can get the document path directly like this.

Very nice - thank you

I got it to work fine like this:

Set wsh = CreateObject("WScript.Shell")
documentsPath = wsh.SpecialFolders("MyDocuments")
Set wsh = Nothing

sPath = "wscript " & documentsPath & "\Script\BlueBeam_v2\CsvConverter.vbs "

Shell sPath & myPath & " ", vbNormalFocus