Run Time Error 9: Subscript Out of Range -- Pivot Table

[XLMaitre]

Hello Everyone.,

I'm new to this forum.

I'm having some trouble running a macro from my personal workbook. I created a macro in another workbook ("Report1") but saved it to my personal workbook.

When I run the run macro in a different workbook ("Report2"), I get a run time error 9 message for subscript out of range. This is what debugging is showing:

Workbooks("08152017 - Report1.xlsx").Connections. _
Add2 _
"WorksheetConnection_08152017 - Report1.xlsx!Table13" _
, "", _
"WORKSHEET;C:\Users\johnsmith\Documents\reports 2017\2017\August\08152017 - Report1.xlsx" _
, "08152017 - Report1.xlsx!Table13", 7, True, False

Any ideas why I keep getting the subscript out of range?

I also created a dynamic table before creating a pivot table because my rows change constantly but the columns remain the same. I do this in order to avoid another more debug issues

Thanks!

 

[XLMaitre]

I'm wondering if this is due to the ".connections" or the other workbook.

Sorry. I'm not fully proficient in VBA.