Hello,
I recorded a chart macro (called "Fill_Test_Graph") which I am trying to run on a bunch of .csv files and once the chart is created save as a .xlsx file.
All the .csv files are named as 1.csv, 2.csv, 3.csv and so on...
So to sum it up I'm trying to:
1. Open the .csv file
2. Run the "Fill_Test_Graph" macro
3. Save as .xlsx
4. Close file
5. Loop to the next .csv file
Thank you.
Last edited by pbd3mon; 11-02-2015 at 10:58 PM.
Hello pbd3mon,
To get an answer quickly, you should upload copies of a CSV file and an example XLSX workbook with the CSV data in place.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Done, thanks for the suggestion.Originally Posted by Leith Ross
Perhaps a macro like this?
You will have to change the folder name where the csv files are stored as well as the name of the save to folder. The way the macro is set up file name will be 1.xlsx, 2.xlsx and so forth.
Alf
Please Login or Register to view this content.
Thank you Alf,
I will give that a try when I get home tonight.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks