run batch job from each row - how to insert run batch function per row?

[Mitchell_Collen via OfficeKB.com]

I have pasted hyperlinks down a spreadsheet in one column. Each hyperlink
navigates to a location of a specific batch file. The path works, however
when I click the link to run the batch, the batch file never executes. Is
there a function available to run programs with the hyperlink? Do you know
what could be wrong? Thanks MC

Ex.

hyperlink

 

[JLatham]

I have pasted hyperlinks down a spreadsheet in one column. Each hyperlink
navigates to a location of a specific batch file. The path works, however
when I click the link to run the batch, the batch file never executes. Is
there a function available to run programs with the hyperlink? Do you know
what could be wrong? Thanks MC

Ex.

hyperlink
-----------------
copyDB.bat
runLogs.bat
setRecord.bat
processCBR.bat

--
Misty

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200902/1

 

[JLatham]

Are they really hyperlinks, not jus text entered into the cells?

I wrote a short .bat file and set up some text in a cell (Excel 2003) and
then used Insert | Hyperlink to actually make it a link to the .bat file.
When I click the hyperlink, it definitely runs... but!! I get system alerts
regarding the security aspects of it all, which is to be expected.

When it does run, the command window opens and closes very rapidly since
this is just a one-line "echo Greetings from your friendly batch file" batch
file. But it does run.

 

[Mitchell_Collen via OfficeKB.com]

JLatham thanks for your help. Do you know how to turn off system alert? -MC

 

[JLatham]

Sorry, actually I don't - or if I do, I've certainly forgotten and a quick
peek around didn't reveal anything or spark my memory.
It's at the Windows OS level, not within Excel, for these particular alerts.
Perhaps if you checked in the one of the Windows related discussion groups
they may have the answer.
Here's a link to the Windows Home Users Security group
http://www.microsoft.com/communitie...3cd-af0a-43fb-9593-5df3d4c2a80a&lang=en&cr=US

Good luck, just remember that if you disable these at the OS level, you may
not get an alert when you need/want it - such as when dealing with malicious
email or other similar problematic situations.

 

[JLatham]

Mitchell_Collen,
Further research along these lines finally led me to the solution for
disabling the "links may be harmful" alerts. The root information is here:
http://support.microsoft.com/kb/829072

I've created two files to disable/re-enable the alert that you can download.
These files have a .txt extension which you will have to change to .reg
before you can use them. I gave them the .txt extension because some
security features on some systems may prevent downloading of .reg files (they
do have the potential for turning your day into a really bad one).

The files are available at:
http://www.jlathamsite.com/uploads/DisableHyperlinkWarnings.txt
http://www.jlathamsite.com/uploads/EnableHyperlinkWarnings.txt

Hope this helps some, especially if you don't already have this information.