Script on toolbar button to launch file into Excel problem

[petersboulton]

Hi,

I like the new custom toolbar buttons and want to make one that launches the currently selected file in the list view into Excel. This is my 'solution':

Code: Select all

::run '"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" <curitem>';

However, when I run it Excel does launch, but displays the message "'<curitem>.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct."

This tells me that XY must be passing through the literal text "curitem" rather than the path of the current item in its command line to Excel! However, I'm a script newbie, so possibly I'm misunderstanding something along the line and am hoping for some enlightenment! Thanks.

Pete

[zer0]

What if you used this script:

Code: Select all

OpenWith "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE";

It defaults to currently selected item and supports the full power of OpenWith UDC.

[Stefan]

This quoting tricked me always too, but it seams i go faster now

Code: Select all

::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>";

[petersboulton]

This quoting tricked me always too, but it seams i go faster now

Code: Select all

::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>";

Thanks Stefan, but your modification gives me a scripting error message box:

"The system cannot find the file specified.
run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "G:\TEMP\prodsNew.tab"

zerO's proposal, (OpenWith "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE";) works, many thanks!

However, is the problem with ::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>"; a bug?

Pete

[zer0]

This quoting tricked me always too, but it seams i go faster now

Code: Select all

::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>";

Thanks Stefan, but your modification gives me a scripting error message box:

"The system cannot find the file specified.
run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "G:\TEMP\prodsNew.tab"

zerO's proposal, (OpenWith "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE";) works, many thanks!

However, is the problem with ::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>"; a bug?

Pete

You're welcome, I'm glad you're up and running with your TB

I believe the reason why Stefan's script doesn't work is because he used Office11 in the address of Excel's location, which suggests that he's on Office 2003. Your original script has Office12 so you're using Office 2007, correct?

[jacky]

However, is the problem with ::run "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "<curitem>"; a bug?

Probably not, as I believe it should be more like this:

Code: Select all

::run """C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"" ""<curitem>""";

And FYI, your first try didn't work because you single-quoted the argument, and variables aren't resolved in single-quoted strings. So, indeed, XY was sending along a literal <curitem> as parameter to Excel.

[petersboulton]

OP here. Sorry, I did not notice the 'Office11' bit. I am Office12 (2007) so I can understand why I got the error message! Sorry about that!

Jacky's script works fine, thanks and I'm sorry I mentioned the B(ug) word. I should know better!

The user defined buttons are another great new feature!

Thanks to all for your help. Appreciated.

Pete