Macros & alternatives

[Bob Phillips]

Mangesh,

The registry restriction should not be a problem as long as your app does
not try to write to the registry. What is being referred to is registry
settings that Excel would change if you modify its configuration, such as
security settings, these are locked down precisely so that you cannot change
the configuration. Your app shouldn't need any such access.

Bob

 

[Bob Phillips]

If you want to protect your code, a VB app of some sort, executable or COM
addin is what you need. But as I mentioned earlier, you will still need
system admin co-operation to get these installed. The problem here is that
you cannot insert code in the Excel worksheet, as it is still macros, and if
the security setting is high, it won't run.

 

[Mangesh Yadav]

Hi Bob,

As I mentioned earlier, if you launch the excel file from a VB app, then it
runs all the macros even though the settings are high (or macros are
disallowed).

And thanks for your suggestions.

Its just that at present I don't know the setup at the client's place. They
have a policy that macros are not allowed. So at the moment I don't know if
this is ensured technically (i.e. the user just cannot change the security
settings). I just wanted to know the available alternatives for me before I
can speak to them. Anyway, will come back again when I get stuck. Thanks for
the help.


Mangesh

 

[Mangesh Yadav]

Hi Nick,

Yes, thats my point. What does the policy mean. As I was replying to Bob,
does it mean that if you have a policy of no macros, then the user cannot
change the security settings, but if there is a technical workout, and you
have a digital certificate, then the user can run my excel app.

Anyway, thanks for the suggestions.

Mangesh

 

[Bob Phillips]

As ever, it is a pleasure.

Good luck with your discussions. Also, remember, the system admin guys will
know about policy and how to manage it within the OS, but it is unlikely
that they will be that conversant with Excel, so they will look to you to
lead them in that area. Show a positive understanding of their situation,
clarity in what you need to do, and you will be amazed at how much you can
achieve.

Regards

Bob

 

[Mangesh Yadav]

Hi Bob,

Thank you very much.

Mangesh

As ever, it is a pleasure.

Good luck with your discussions. Also, remember, the system admin guys will
know about policy and how to manage it within the OS, but it is unlikely
that they will be that conversant with Excel, so they will look to you to
lead them in that area. Show a positive understanding of their situation,
clarity in what you need to do, and you will be amazed at how much you can
achieve.

Regards

Bob

before time,