Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
I am hyperlinking to a script file in Excel 2007. I get a pop-up
warning asking if I want to open the file. I have read that you can "run a program" in excel somehow to get around this annoying warning pop-up. I am not sure how to do this though. Another way could be to do this in VB. Unfortunately I am not versed in programming, and am having a hard time trying to figure out how to do this in VB. Anyone have any ideas. or can help me with running this "file" through VB? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
Alden,
There are several different types of script files. Are you talking about a vbScript, javascript, batch file or some other type script file? Will the script file be generating information you want to retrieve or do you simply want it to run? Steve "Alden" wrote in message ... I am hyperlinking to a script file in Excel 2007. I get a pop-up warning asking if I want to open the file. I have read that you can "run a program" in excel somehow to get around this annoying warning pop-up. I am not sure how to do this though. Another way could be to do this in VB. Unfortunately I am not versed in programming, and am having a hard time trying to figure out how to do this in VB. Anyone have any ideas. or can help me with running this "file" through VB? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
On Aug 16, 3:13*pm, "Steve Yandl" wrote:
Alden, There are several different types of script files. *Are you talking about a vbScript, javascript, batch file or some other type script file? *Will the script file be generating information you want to retrieve or do you simply want it to run? Steve "Alden" wrote in message ... I am hyperlinking to a script file in Excel 2007. I get a pop-up warning asking if I want to open the file. I have read that you can "run a program" in excel somehow to get around this annoying warning pop-up. I am not sure how to do this though. Another way could be to do this in VB. Unfortunately I am not versed in programming, and am having a hard time trying to figure out how to do this in VB. Anyone have any ideas. or can help me with running this "file" through VB?- Hide quoted text - - Show quoted text - Yes Steve, it is a CMS (program) script file (.acsup). I have it setup to dump the needed data intop a text file that Excel has a connection to. I have continuted searching today and it appears that the only way will be through a digital certificate. I tried useing a "self cert" but that didn't work... I am not sure what it would take to get it certified through my company, as I know that we can do this due to our size, etc. We just don't have access to those types of things in our branch. Perhaps you can still assist? Thanks for taking the time to ask! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
Ive used SelfCert Certificates for years on XP. With Very Little
Problem. Each User Simply needs to Add the Certificate To its Trusted list to allow the Macros to Run Successfully. HTH, Andrew "Alden" wrote in message ... On Aug 16, 3:13 pm, "Steve Yandl" wrote: Alden, There are several different types of script files. Are you talking about a vbScript, javascript, batch file or some other type script file? Will the script file be generating information you want to retrieve or do you simply want it to run? Steve "Alden" wrote in message ... I am hyperlinking to a script file in Excel 2007. I get a pop-up warning asking if I want to open the file. I have read that you can "run a program" in excel somehow to get around this annoying warning pop-up. I am not sure how to do this though. Another way could be to do this in VB. Unfortunately I am not versed in programming, and am having a hard time trying to figure out how to do this in VB. Anyone have any ideas. or can help me with running this "file" through VB?- Hide quoted text - - Show quoted text - Yes Steve, it is a CMS (program) script file (.acsup). I have it setup to dump the needed data intop a text file that Excel has a connection to. I have continuted searching today and it appears that the only way will be through a digital certificate. I tried useing a "self cert" but that didn't work... I am not sure what it would take to get it certified through my company, as I know that we can do this due to our size, etc. We just don't have access to those types of things in our branch. Perhaps you can still assist? Thanks for taking the time to ask! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
On Aug 16, 4:09*pm, "Andrew" wrote:
Ive used SelfCert Certificates for years on XP. *With Very Little Problem. Each User Simply needs to Add the Certificate To its Trusted list to allow the Macros to Run Successfully. HTH, Andrew I think I figured something out, playing around today I do not get the prompt to add a publisher from the initial warning on the Excel file's opening. I added a trusted location and that did away with that. It seems that the certificate is stopping that prompt in the same way. Great! What I am looking for though is to do away with the pop-up warning everytime the macro is run that selects a hyperlink. Using a digital certificate does not seem to affect that. I want to make a document that selects many hyperlinks, and numerous pop-ups are annoying, to say the least. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
This MS KB Article shows you how to disable that warning.
http://support.microsoft.com/?kbid=829072 Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 10:48:01 -0700 (PDT), Alden wrote: On Aug 16, 4:09*pm, "Andrew" wrote: Ive used SelfCert Certificates for years on XP. *With Very Little Problem. Each User Simply needs to Add the Certificate To its Trusted list to allow the Macros to Run Successfully. HTH, Andrew I think I figured something out, playing around today I do not get the prompt to add a publisher from the initial warning on the Excel file's opening. I added a trusted location and that did away with that. It seems that the certificate is stopping that prompt in the same way. Great! What I am looking for though is to do away with the pop-up warning everytime the macro is run that selects a hyperlink. Using a digital certificate does not seem to affect that. I want to make a document that selects many hyperlinks, and numerous pop-ups are annoying, to say the least. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run file from VB in Excel
On Aug 18, 2:55*pm, Gord Dibben <gorddibbATshawDOTca wrote:
This MS KB Article shows you how to disable that warning. http://support.microsoft.com/?kbid=829072 Gord Dibben *MS Excel MVP Thanks Gord. Unfortunately, I can not do this for everyone that this workbook will be used by. I think another option is to look into doing an automatic script that would be activated by Windows scheduler as opposed to an interactive (Avaya CMS's terms) script activated by a hyperlink. I am not sure if my company will allow me to do what I need. The spreadsheet is a seating chart, and I was hoping to make it push button instead of copy and paste from the CMS application. (More will actually use it... among other reasons.) Being a seating chart, I was hoping to have it updated "real time" instead of being a dealy inbetween automatic updates. But oh well! Thanks again everyone! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
ExtenXLS loads data into Excel 2002 file but damages the Excel file. | Excel Programming | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Use ADO to transfer data from open excel file to closed excel file | Excel Programming |