environment variables set when Excel already open

[christhedonstar]

Hi,

If I open Excel and then create an environment variable on my computer, I cannot see that environment variable when I use environ("myEnvironmentVariable"). Also cannot see it if I use the WScript.Shell.ExpandEnvironmentStrings("%" & myEnvironmentVariable & "%") function.

I only can see it if I restart Excel and run those functions. Is there anyway to get the variable value without restarting Excel?

Thanks in advance,

Chris

 

[PHV]

and then create an environment variable
How do you create the environment variable ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[christhedonstar]

With c# process that is shelled out to when the workbook opens in Excel. If I open up a new command prompt and type "set" then I'll see the environment variable.

Thanks,

Chris

 

[christhedonstar]

Any ideas?

 

[christhedonstar]

Perhaps its not possible? I'm starting to get the feeling as I've spent a while searching for the answer.