Quick Batch File Question

[karldenton]

Managed to solve a problem I had by using a batch file.

A link on our intranet now runs the bat to open an excel file.

 

Is there a way when the user clicks the link to run the batch without it asking to Run, Save etc

Thanks

[tmcd35]

Instead of running a batch file to open an excel file how about making a new excel shortcut and modifying the Target to include the name/location of the excel file you want opening after the path to excel:

 

Target: "C:\program files\microsoft office\office 11\excel.exe c:\my documents\nameofexelfile.xls"

[karldenton]

Thanks but unfortuntely its a link on Joomla and Joomla changes the code to an absolute link so it doesn't work

[karldenton]

Its just the Run, Save dialog box that i want to remove. Just want it to run automatically.

[OutToLunch]

You will always get the security warning dialog when launching an app from a webpage, the only way around this I know is to install an addon for IE, not sure if this will have been updated for 7/8 though.

[karldenton]

Thanks. Where can i get the addon from ?

[sted]

cant you add the site to ie's local intranet group i think that allows this without questions

[Guest TheLibrarian]

IIRC there are settings that the webserver can have that tell the browser how to handle certain file types.

 

Don't ask me how or where because I don't know, it's just one of those useless snippets I've squirrelled away.

[karldenton]

Just to update on this. The staff are managing to click the Run dialog box which is good.

 

However 1 machine has Office 2003 where the rest have Office 2000.

 

Is there a way to run the batch so if 2000 isn't present it will load 2003.

 

IE

"C:\Program Files\Microsoft Office\OFFICE\EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"

then on next line.

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"

[Jamman960]

 

Is there a way to run the batch so if 2000 isn't present it will load 2003.

 

IE

"C:\Program Files\Microsoft Office\OFFICE\EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"

then on next line.

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"

 

Office executables will usually launch without a full path even though the path isnt within the system path so using

"EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"

should work.

 

James

Edited November 5, 2009 by Jamman960

[karldenton]

Nope,

Just putting "Excel.exe" didn't work for 2003 or 2007