|
run batch job from each row - how to insert run batch function per row?
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.a...excel/200902/1 |
run batch job from each row - how to insert run batch function per
"Mitchell_Collen via OfficeKB.com" wrote: 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.a...excel/200902/1 |
run batch job from each row - how to insert run batch function per
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" wrote: 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.a...excel/200902/1 |
run batch job from each row - how to insert run batch function per
JLatham thanks for your help. Do you know how to turn off system alert? -MC
regarding the security aspects of it all, which is to be expected. -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
run batch job from each row - how to insert run batch function
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/communities...&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. "Mitchell_Collen via OfficeKB.com" wrote: JLatham thanks for your help. Do you know how to turn off system alert? -MC regarding the security aspects of it all, which is to be expected. -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
run batch job from each row - how to insert run batch function per
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 he 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/D...nkWarnings.txt http://www.jlathamsite.com/uploads/E...nkWarnings.txt Hope this helps some, especially if you don't already have this information. "Mitchell_Collen via OfficeKB.com" wrote: 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.a...excel/200902/1 |
| All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com