+ Post New Thread
Results 1 to 11 of 11
Windows Thread, Quick Batch File Question in Technical; Managed to solve a problem I had by using a batch file. A link on our intranet now runs the ...
  1. #1

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19

    Quick Batch File Question

    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

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,665
    Thank Post
    850
    Thanked 893 Times in 738 Posts
    Blog Entries
    9
    Rep Power
    328
    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:

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

  3. #3

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Thanks but unfortuntely its a link on Joomla and Joomla changes the code to an absolute link so it doesn't work

  4. #4

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Its just the Run, Save dialog box that i want to remove. Just want it to run automatically.

  5. #5

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    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.

  6. #6

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Thanks. Where can i get the addon from ?

  7. #7


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,591
    Thank Post
    228
    Thanked 856 Times in 735 Posts
    Rep Power
    296
    cant you add the site to ie's local intranet group i think that allows this without questions

  8. #8
    TheLibrarian
    Guest
    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.

  9. #9

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    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"

  10. #10
    Jamman960's Avatar
    Join Date
    Sep 2007
    Location
    London/Kent
    Posts
    989
    Thank Post
    186
    Thanked 194 Times in 156 Posts
    Rep Power
    46
    Quote Originally Posted by karldenton View Post

    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
    Code:
    "EXCEL.exe" "\\server\sharedarea\_Teacher Admin\The Staffroom\Pupil Notices.xls"
    should work.

    James
    Last edited by Jamman960; 5th November 2009 at 12:18 PM.

  11. #11

    Join Date
    Apr 2007
    Location
    York
    Posts
    558
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Nope,
    Just putting "Excel.exe" didn't work for 2003 or 2007

SHARE:
+ Post New Thread

Similar Threads

  1. Default Printer Batch File
    By karldenton in forum Windows
    Replies: 13
    Last Post: 23rd March 2010, 05:16 PM
  2. batch file for temporary profiles
    By gshaikh in forum Windows
    Replies: 4
    Last Post: 7th October 2008, 09:16 AM
  3. batch file comman
    By jussy65 in forum Scripts
    Replies: 3
    Last Post: 13th August 2008, 07:10 AM
  4. Pass £ in batch file
    By meastaugh1 in forum Windows
    Replies: 2
    Last Post: 17th January 2008, 08:02 PM
  5. batch file help
    By beeswax in forum Scripts
    Replies: 9
    Last Post: 3rd March 2006, 07:48 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •