"Trust access to Visual Basic project" for the IUSR account

[Martin. D. Waller]

Hello,

I have a system where I automate Excel from an ASP page. The problem I have
is that I need to ensure that the "Trust access to Visual Basic project"
setting is set for the IUSR account - what is the best way to ensure this ?

Many thanks....

Martin

 

[Cindy M -WordMVP-]

Hi Martin.,

I have a system where I automate Excel from an ASP page. The problem I have
is that I need to ensure that the "Trust access to Visual Basic project"
setting is set for the IUSR account - what is the best way to ensure this ?

Now, that would negate the entire purpose of having the setting, wouldn't it,
if one could change it using code?

You'd have to send the user a message, asking him to check and change the
setting. Of course, if the user is in a securely administered environment, he
might not be able to change it...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Martin. D. Waller]

I totally disagree. I want my ASP application to be able to automate Excel,
create a new spreadsheet and associated VBA code with it. I then want it to
populate the spreadsheet with data and execute a macro stored within the VBA
code. I then want to send the generated spreadsheet back to the Internet
Explorer user.

The only problem I have is ensuring that the "Trust access to Visual Basic
project" is set in the IUSR hive. I can do this by setting the IUSR password
to something and logging in as that user and setting the bit and logging
out. I just think that there has to be a better way of doing it...

Martin