elbarauljr
New Member
- Joined
- May 4, 2020
- Messages
- 19
- Office Version
- 365
- 2007
- Platform
- Windows
Hi,
I am new to this forum, and very exited to be part of it. I would appreciate to get help with a macro coding that allows me to do the following actions:
1. I already have open: "Raw Expenses", "Raw Encumbrances", "Raw Funding" and "Raw Tasks" .csv files that I export from a Web base program.
2. The need to open "Master Data" workbook to paste from each .csv file above the range (A1:J1200) to a specific sheet ("Expenses", "Encumbrances", "Funding" and "Tasks") starting in cell D1. Input today date on sheet 1 A1, then save/close the "Master Data" workbook.
3. Finally for backup purpose, I need to SaveAs each .csv file as .xlsx with name "yyyy mm dd Expenses", "yyyy mm dd Encumbrances", "yyyy mm dd Funding" and "yyyy mm dd Tasks" under same drive location.
Thank you in advance.
I am new to this forum, and very exited to be part of it. I would appreciate to get help with a macro coding that allows me to do the following actions:
1. I already have open: "Raw Expenses", "Raw Encumbrances", "Raw Funding" and "Raw Tasks" .csv files that I export from a Web base program.
2. The need to open "Master Data" workbook to paste from each .csv file above the range (A1:J1200) to a specific sheet ("Expenses", "Encumbrances", "Funding" and "Tasks") starting in cell D1. Input today date on sheet 1 A1, then save/close the "Master Data" workbook.
3. Finally for backup purpose, I need to SaveAs each .csv file as .xlsx with name "yyyy mm dd Expenses", "yyyy mm dd Encumbrances", "yyyy mm dd Funding" and "yyyy mm dd Tasks" under same drive location.
Thank you in advance.