How to change park n go selection via VB macro?

[former_member189599]

Hi Gurues!

I'm working in SAP BPC 7.5 version.

I have one macro to send data from an input schedule workbook, that was distributed.

When the file is collected, it was with the state: "offline". So, I need to make it online so, I can refresh data.

It is possible change the park n go value via macro?

thanks!

LUCAS

[former_member186338 · Accepted solution]

Hi lucas,

Please read help: VBA Variables - SAP BusinessObjects Planning and Consolidation - SAP Library

EV__LOCKSTATUS__ =0

Vadim

P.S. Like

[former_member189599 · Accepted solution]

Hi Vadim!

Tanks for your answer!

We have a VB macro in an Excel file that does the following:

1. Request a folder to collect files that were submitted by users.

2. Copy the original files to another folder named "Copia_xxxxx"

3. Open one by one and refreshes the original files (without sending data)

4. Put as "very visible" the "EVDRE_CACHE" and the copy sheet.

5. Open the file of the corresponding copy.

6. Put as "very visible" the "EVDRE_CACHE" road and erases its contents.

7. Paste the contents of the "EVDRE_CACHE" point 4 (cache refreshed the original file). sheet

The problem is that the sentence: "Application.Run (" MNU_eTOOLS_REFRESH ")" is executed for the workbook where the macro is not in the template we need.

Can you tell me how to make it refreshed the template?

Thanks

LUCAS

[former_member186338 · Accepted solution]

"The problem is that the sentence: "Application.Run (" MNU_eTOOLS_REFRESH ")" is executed for the workbook where the macro is not in the template we need." - sorry but absolutely not clear!

And not related to the original question...

The trick with EVDRE_CACHE to rewrite all data is well known

[former_member186338 · Accepted solution]

By the way, we are using slightly different method to "repair" EVDRE_CACHE:

1. Copy received file to some temporary name.

2. Refresh copy (discarding data entered by users)

3. Replace EVDRE_CACHE in the original file with EVDRE_CACHE from the refreshed copy.

Then only changed values will be sent!

Vadim

[former_member189599 · Accepted solution]

Hi Vadim.

In the macro, we are executing the sentence: Application.Run (" MNU_eTOOLS_REFRESH ")" to refresh the data from template, but this action is executed in the file with the button (that trigger the macro) and not in the template, so files are not refreshed.

File with button (=macro)

 

Template with data to refresh (with out macro)

Macro Code

I hope been more clear.

Thanks

LUCAS

[former_member186338 · Accepted solution]

Absolutely strange code...

You have some macro in the file with the button.

You open the template with data.

Then you have to activate some sheet with EVDRE

Then you can refresh it with:

Application.Run "MNU_eTOOLS_REFRESH"

...