Run file from VB in Excel

A

Alden

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?
 
S

Steve Yandl

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
 
A

Alden

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







- 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!
 
A

Andrew

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,

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







- 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!
 
A

Alden

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.
 
A

Alden

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top