VBA Local folder for Planning and Consolidation (BPC 7.5)

[Former Member]

Hi Experts,

I am trying to get the address of the local folder for Planning and Consolidation via VBA, but I do not know how.

I haven't found any direct vba function, so any idea on how to get the address via macro?

Thanks in advance,

J. Ignacio

[Former Member]

Hi Vadim,

Please look at the image I've just attached.

It's the local folder where all the temp files are installed (besides other files)

Thanks,

J. Ignacio

[former_member186338]

There is no documented function!

But what for?

Vadim

[Former Member]

I have written a VBA function that needs to Access the dimension porperties (XML in the local foler) when being offline.

It works perfectly from my computer, but I need the path that would work from any computer.

Thanks.

[former_member186338]

Hi Ignacio,

I do not recommend to assume that you will find the PC_NW folder, especially when being offline. For offline you have work with info stored in the template Excel file. For online you can use EXPAND to fill the list of members with the properties on some temporary Excel sheet.

Please, explain the requirements.

Vadim

[former_member186338]

"local folder" - what do you mean?

Vadim