Help with VB Code to pass a selection to another workbook's slicer

Hi All

I would appreciate you help on the following problem.

I have two workbooks each having power Pivot Tables on them. From workbook1 user is presented with a choice of which salesperson's report they want to open. What I need is a code that based on Selection in workbook1 then Workbook2 will open and the slicers in Workbook2 will have the correct name already selected that matches the selection in workbook2. I have the coide which opens the report in WB2 but not sure how to pass the sleection from Combobox in WB1 to WB2's slicer. I.e. if user selects John in WB1's ComboBox then WB2 will open and the slicer value for name will be set to John so only John's data is visible.

Is this possible at all?

Thanks in advance

Hi rv02,

This is possible.
I would create a Function on the Second Sheet that takes a Slicername and a string Array as parameters
Then put the Selection of the first sheet into an Array
Open the 2nd Workbook and call the Function passing the Array and Slicername.

Greets
Loki

Thanks for your help I wil ltry this

if you can post the 2 workbooks as an example i can help you with the Code.
Without that its a little bit tricky to help cause the slicer part can be very strange :D
When i am home later i can try give you an example workbook.
I did a lot coding with slicers so i know they are a pain in the *** :D

I have attcahed two very simple worokbook to demonstrate what I need to do.

In Wb1 youcan select a neame of the sale sperson and once you click on OK I need WB2 to open and the slicer in Pivot report sheet (Report) to automatically select the which was chosen in WB1.

I hope this make sense, and thank for your help.

Cool that will help. I just found out that the slicer thing is a bit more complicated with powerpivot. But it's still doable. Will check on that later.

Gesendet von meinem HTC One mit Tapatalk

I looked at your Sheets and i need you to specifiy again what is the Source for the Slicer is it a normal Pivot or a Pivot from PowerPivot which is a special Addin

Cause the Approach for powerpivot is different and more complex.
And in your example Sheet you have a normal Pivot

Also in the Source File the user can Only select one Entry is that Correct for the Rea thing too?

Greets
Loki

Unfirtunatle the source is from Power Pivot.

Hi rv02,

Attached you find an example with 2 workbooks
just store them both in the same folder and run the selector
the code for selection is in the data file and gets executed when you open it via selector file

greets
Loki

Dear Loki

Thank you so much for your help and your time. This is perfect and its excatly what I needed.