Defining a workbook, worksheet, with R1C1

[TeloS53]

hey guys !

So, i have 2 questions, i am trying to paste the getpivotdata formula in a cell, but the formula is coming from another workbook, so i would like to know if there is a way to define them, to adapt them in the formula. I have put in bold what i would like you to automatize...
Second question, i would like to know if it is possible to automatically change the number at the end of the formula, to adapt to each code in a range of cells, that i would look up for first, and then doing a loop until the end

By advance, thanks

Please Login or Register  to view this content.

[AlphaFrog]

You would concatenate the variable values within the formula string.

Something like this...

Please Login or Register  to view this content.

[TeloS53]

Thank you very much, but i still obtain this error :

Runtime error 1004
application-defined of object-defined error :/. I don't understand, because when i go to the debugger, i point on the wbk2.fullname and sheet and it shows the good parameters... I precise that i did not change the cell.value part

[TeloS53]

So, here is my new code :

Please Login or Register  to view this content.

Still got that "Runtime error 1004
application-defined of object-defined error" :/ error, no one has an idea why ??