Using Variables in the Run Function

[HeidiR]

Is it possible to use variables in the Run function? The example below does not open the file foo.xls. Instead Excel produces an error indicating that it can not open $path.xls.

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e $path & "foo.xls"', "", @SW_MAXIMIZE)

[crzftx]

It is very possible, but you have the variable inside of a string. Try something like:

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e "' & $path & 'foo.xls"', "", @SW_MAXIMIZE)

Edited July 23, 2008 by crzftx

[DaRam]

Try:

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE /e "' &  $path & 'foo.xls"', "", @SW_MAXIMIZE)

Is it possible to use variables in the Run function? The example below does not open the file foo.xls. Instead Excel produces an error indicating that it can not open $path.xls.

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e $path & "foo.xls"', "", @SW_MAXIMIZE)

[HeidiR]

Thanks for the information guys! Unfortunately, I could not get either solution to work. I tried the line below combining the path and file name in one variable. However, I could not get this to work either. obviously, I don't understand what the Run syntax should be with variables! Any ideas?

Run('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e & $path_file_name', "", @SW_MAXIMIZE)

[James]

Is it possible to use variables in the Run function? The example below does not open the file foo.xls. Instead Excel produces an error indicating that it can not open $path.xls.

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e $path & "foo.xls"', "", @SW_MAXIMIZE)

Run ('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e $path & "\foo.xls"', "", @SW_MAXIMIZE)

Try using this format:

$Path = @MyDocumentsDir
Run($Path & '\My document.xls')

Edited July 23, 2008 by JamesBrooks

[HeidiR]

Thanks to all for the help! After some additional research, I was able to get the following Run statement to work:

Run('"D:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e "' & $path_file_name & '"', "", @SW_MAXIMIZE)

But not sure I understand why! :-)