How to enter %PC1driveD% into .vbs? System environment variable PC1DriveD defined as d:

[Sometimes]

PC2 needs to access the files on PC1,
thus sysvar on PC2 defines PC1DriveD as a networked drive letter.

Same sharing concept needed if use USB with fname and attach to laptop.

My .bat code worked flawlessly using %PC1DriveD%\fname.xlsm

Now, using .vbs, this works:

Please Login or Register  to view this content.

I've actually spent weeks unsuccessfully trying to resolve this puzzle

THANKS!

[LJMetzger]

Hi Sometimes,

The following may help you resolve your problem:

Please Login or Register  to view this content.

Lewis

[Sometimes]

Lewis, thank you so much for the quick response.

I had tried various drafts of GetEnvironmentVariableValue,
and I learned about all kinds of possible error combinations
on my part!

I must be daft, but here's what I entered, and I got
"Expected end of statement" for " Dim sDriveLetter As String"


Exact code entered is
~~~~~~~~~~~~~~~~~~~~~

Please Login or Register  to view this content.

[LJMetzger]

I have to apologize, because I gave the right answer to the wrong question. I thought you wanted to read the environment variable in Excel VBA.

Your question seems to be a VBS question. The following thread may help you read Environment variables in VBS: http://ss64.com/vb/env.html

The Forum Rules require you to add CODE TAGS when you post code, and require no answers until the CODE TAGS are in place. See http://www.excelforum.com/forum-rule...rum-rules.html

Lewis