1.

Solve : Path with a variable?

Answer»

I have made a BAT for launching :

"M:\Archivos de programa\Microsoft Office\Office10\WINWORD.EXE" /t "Y:\GABINETE\PROYECTOS\125.09\125.09.Proyecto.doc" /mmacro3

wproof.bat

The bat opens a word document and goes to a bookmark inside executing a macro associated to word.
The bat is launched from an excel cell by a HYPERLINK

But I need the expression "125.09" to be CONSIDERED a variable proposed in another excel cell.


I don't know if this is possible, so any additional consideration is welcome. First time I thought that the variable may be an environmental variable of windows xp system.
Or perhaps a variable in an ini file.
O simple a variable I can define with the excel cell content.
Or perhaps the bat may propose introduce the variable value with no problem and propose that value in the excel cell as a memory help of the expedient is opened.
"125.09" is the expedient reference.

So :

"%PROGRAMFILES%\Microsoft Office\Office10\WINWORD.EXE" /t "Y:\GABINETE\PROYECTOS\%xvar%\%xvar%.Proyecto.doc" /mmacro3


*******************
@ echo off
set xvar = %1


How can I do please ?


How can I propose the variable value in an excel cell ?

How can I define exactly the variable ?

BEST Regards










Discussion

No Comment Found