Turn off "Enable Macros" prompt in command line

[ainkca]

Hi all,

Does anyone know how to stop the warning a user gets when they're about to open a report with VB code? (document contains macros... enable or disable).

Since you can go into tools and set "Always ask before opening documents with Macros" one would assume that you can set this variable to false at the time the report is run. I'd like to do it inside the command line, but I haven't been successful discovering the right code.

Just setting it from within tools doesn't do it though... the info seems to be stored at the user level, and not the BO level. So when it's me looking at a report, it doesn't ask, but the users get asked.

We don't use Broadcast Agent. We have BO installed on servers, and run it in a CITRIX environment. So every user has to answer the prompt on every server at least once, and every time the report is changed they have to do it again.

Any thoughts?Thanks in advance for any help.
ainkca

 

[erwan]

Hello !
I am sorry but i don't have the solution for you.

but i see that you are using BO with Citrix. Is it a good solution and is it working well. We are going to start a study on it (on december).
If you are some advices about this solution they will be welcomed
Thanks

Erwan

 

[ainkca]

Erwan,

We are running Citrix on Windows NT 4 Terminal Servers, and we do load balancing.

Business Objects is installed and set up on each server so that the paths are the same.

Since we don't have Broadcast Agent, and our users are hitting potentially a different server each time, the reports are copied to each server. Not a big deal really, I develop on one server, then when it's ready I copy it to the other servers.

As far as automation, I have used VBA in Access, etc to do essentially the same things Broadcast Agent does.

I've has my share of wanting to run screaming from the room, but all in all, I'd have to say that it's working out well. Most of my frustrations have come from having nowhere to turn for questions. Hoping this list will help.

Regards,
ainkca

 

[erwan]

thanks for this infos.
Erwan

 

[deaco]

ainkca,

The Option 'Always ask before opening documents with macros' is held in the registry. What you have with citrix is a dynamic registy on the servers so you find that the users Local registry settings are probably lost for business objects each time they logoff. I had the same problem and wanted to set the Options for users everytime they logged in, even if they chose to change them while they were logged on. I achieved this by running a simple registry Key file whenever the user either ran the Business Objects Icon (by linking it to a batch file that ran the registry update and then BOb) or by running a usrlogon.cmd script when they logged onto the server.
There are two ways of adding the registry key. If the users are logging onto your Citrix Servers Anonymously they will be picking up the Business Objects Default Users settings, if they are logging on as themselves each time then you can identify the user and find their particular registry key.

The Key you want is :-

[HKEY_LOCAL_MACHINE\Software\Business Objects\BusinessObjects\5.0\BusObj General Preferences\busobj\Options\General]
"ShowWelcomeWizard"=dword:00000000
"AutoImportUniverses"=dword:00000000
"ReopenLastOpenDoc"=dword:00000000
"NotifyDocumentReception"=dword:00000000
"ShowMRUList"=dword:00000000
"MRUListNumber"=dword:00000000
"PictureEditor"=""
"AlwaysAskEnableMacroDlg"=dword:00000000

This is the entire sub-key for the default user but it's pretty obvious what the different lines are. Set the last zero to a 1 to tick the boxes by default.

BEFORE EDITING A REGISTRY MAKE SURE THAT YOU HAVE A COPY OF THE REGISTRY. BEFORE IMPLEMENTING ANYTHING LIKE THIS TEST AND RE-TEST IT.

It took quite a few attempts to get all of the settings exactly how I wanted them. The above general key shows you where all of the Business Objects registry settings are so have a play and find some of the things you can do.

Hope this helps

 

[ainkca]

YES! That sounds like it will be exactly what I need. I'm out of the office today, so I'll try it next week. Thanks so much!