ncomper
asked on
Excel Macros to import a .csv file into a workbook
Hi,
I need help creating a macro that will import a .csv file into a workbook and refresh the pivot tables, is this possible and what would be the best method for achieving this?
The two files I've uploaded contain some of the raw data (File name: "Data to be imported") that needs to be loaded into the workbook automatically (File name: "Report Template").
Please advise.
Many Thanks,
Tom
Data-to-be-imported.csv
Report-Template.xlsx
I need help creating a macro that will import a .csv file into a workbook and refresh the pivot tables, is this possible and what would be the best method for achieving this?
The two files I've uploaded contain some of the raw data (File name: "Data to be imported") that needs to be loaded into the workbook automatically (File name: "Report Template").
Please advise.
Many Thanks,
Tom
Data-to-be-imported.csv
Report-Template.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help here, script worked perfectly
ASKER
Thanks for this!
I've spent some time playing around with the above macro today and the only issue had is when it comes to the Line Breaks in the imported data. This causes a single line of data to be spread across additional rows, I've looked around the web and cannot find a solution to this, any recommendations on where to look?
Many Thanks,