Skip to Content
Former Member
Jan 15, 2009 at 08:51 AM

Refresh workbooks on open without dialog (and remote variable maintenance)


Hi all ,

Hi Marc ( I am posting this question here as you aked me for)

I have one important question concerning BEx7 API.

Here at current custmer I look for a way to populate the Filter (Variables) values

our users maintained in the variable Dialog and saved with workbooks.

Our problem is that we like to set the stored variable values to a specific

value for all workbooks.

In BEx 3 I could populate the variables in hidden sheets of Bex 3.

In BEx 7 I found out that the variable values are stored with the

BExRepositorySheet in XML string.

The problem we have here in Germany at Banking services is:

The Script editor to review the hidden information in the Repository sheet will notbe


Another problem, with Excel 2007 the script functionality is completely

gone and when storing workbooks locally (PC Client) the system also will warn endusers

that script will not be stored in Excel files (Excel2007).

Do you have any idea how I can save a specific value for a variable in the

new BEx7 without using the dialog boxes.

I am looking for a VBA way to populate or exchange the stored values

because we have to exchange some specific values

We have several hundred workbooks and I like to save the value in an

automated way to prepopulate variables in workbooks.

If you have a hint or whatever feature or if you can forward me to some

colleague who might have the information would be great.