modify a environmental variable with a bat

[Esgrimidor]

Mi PC - properties (propiedades) - Advanced options (opciones avanzadas) - environmental variables (variables de entorno) - ....

Can I modify an environmental variable (user variable or system variable) with a script ?

a bat or vbs .... ?

Thanksxxxx

[Salmon Trout]

setx; see other thread

[Esgrimidor]

Working Salmon Trout.

The first time don't go well because I don't exit the bat.

But now goes well perfectly.

And I think a reg writing the environmental variable to the registry gives good result also.

What do you think ?

 

[Salmon Trout]

Working Salmon Trout.

The first time don't go well because I don't exit the bat.

But now goes well perfectly.

And I think a reg writing the environmental variable to the registry gives good result also.

What do you think ?

 

Yes, if that is easier; modifying the registry is what setx actually does. And what modifying environment variables in Control Panel does.

[Esgrimidor]

I'm trying with no good result propose the environmental variable in an excell cell.

With the function environ()
But I do bad.


If I want propose the cell D52 and the variable varexpediente what can I do ?

I have tried =environ("varexpediente") with no results

 

[Salmon Trout]

Did you use the Macro Editor and create a VBA function (like I showed you in the other thread)?

here: http://www.computerhope.com/forum/index.php/topic,90865.0.html

[inapaler]

I like it...

this really good..
Thanks  a lot.

[Esgrimidor]

You are completely right. I need revise the other post.

 

There is a lot of important information I have to study.

the information about the txt file (or ini file perhaps) I think is very revealing.

[Salmon Trout]

en garde!

[Esgrimidor]

I have been making a lot of proofs and seemed to be :

1. I used setx for changing environmental variables. And get it because examining Mi PC - properties..... . I observ the new value.

but inside excel seem not to be affected, or the bat created to execute the word doc with the variable path.

It's this correct. The change is not instantanous.....

2. I use a .reg file to change the environmental variable with good results, but this change seem take not effect in my bat file or inside excel.


So I'll try to close user session or reiniate the system and comment. ......





Edited : The problem is that the variables are not refreshed instanly in excel.

1. Really I don't need reiniate o close user session. What I did to obtain the actual value of varexpediente in the excel cells was re-write in the cells the name of the variable or the formula and goes well. .....

There is no way of appearing instanly the new value of the variable varexpediente ?

2. The other method with the text file goes well. I obtain instanly the same result in the cell, in the hyperlink and in the text file .txt .