Hello All.
The code I have below, is working from the recorder, to select my source Data for my Pivot Chart. The problem, is it specifically looks for the file in the company network, so I can not send it to anybody because it will not work.
Is there a way to make it a local file? And, for some reason, every time I run my macro, I have to go back and reselect the data source for the Pivot Chart, because it only wants to retain the header of the data source, and not the entire data set.
Thanks for the help
The code I have below, is working from the recorder, to select my source Data for my Pivot Chart. The problem, is it specifically looks for the file in the company network, so I can not send it to anybody because it will not work.
Is there a way to make it a local file? And, for some reason, every time I run my macro, I have to go back and reselect the data source for the Pivot Chart, because it only wants to retain the header of the data source, and not the entire data set.
Thanks for the help
VBA Code:
Sheets("Spray Booth 1 PVT").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveSheet.PivotTables("PivotTable1").ChangePivotCache ActiveWorkbook. _
PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"\\lbgert01\PlasticsEng\Sam\Projects\RFID\RFID Macro\[Datalog Conversion_9-22-2021 - Copy - Copy.xlsm]Spray Booth 1!R1C1:R2634C9" _
, Version:=7)
Range("A1").Select