Forum Discussion
VBA: Limit to Rows for a Pivot Table
I'm working on a macro which will run across several .csv files. The goal is to take a .csv file, create a new blank worksheet, and add a Pivot Table using the .csv data as the source. The .csv files...
It's not. It's saved as a .csv when I run the macro.
Does it need to be saved as .xls or .xlsx first?
TBH I don't know. Instead of just opening the CSV files you could use Data, From Text to import a CSV file into an existing sheet. Then you can click Data, Refresh All to have Excel ask for another CSV, it'll update the data for you and update the pivottable. Then save-as the file to a new name to keep the current CSV/pivottable combination.