|
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
|