tombrown65
New Member
- Joined
- Jun 9, 2021
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi Guys,
I need a quick primer that I can work from; once I have the basics I can normally build on it to get to the end
I have a master template in excel that I have put some formulae & macros in so that when I copy a csv file into one tab another tab collates all the data into a summary table, including sorting it alphabetically and removing some spurious entries. At the moment I save the master template first as a new filename, then copy the csv content in, then run the macros.
I would like to have a macro that displays a dialog box that prompts for a new filename to save the template to. If that was all I wanted to do I could just use Application.GetSaveAsFilename. However I want the same Dialog box to have a file picker field for the csv input file - i.e. in one dialog I pick both the input & output filenames, and store them as variable, so I can then save as one and open the other to copy data across.
As an added bonus if there is an easy way of copying the content of a csv into a tab in the excel workbook (other than select copy & paste) that would be great.
Apologies if this is answered elsewhere - I did a quick search, but couldnt find anything obvious
thanks
I need a quick primer that I can work from; once I have the basics I can normally build on it to get to the end
I have a master template in excel that I have put some formulae & macros in so that when I copy a csv file into one tab another tab collates all the data into a summary table, including sorting it alphabetically and removing some spurious entries. At the moment I save the master template first as a new filename, then copy the csv content in, then run the macros.
I would like to have a macro that displays a dialog box that prompts for a new filename to save the template to. If that was all I wanted to do I could just use Application.GetSaveAsFilename. However I want the same Dialog box to have a file picker field for the csv input file - i.e. in one dialog I pick both the input & output filenames, and store them as variable, so I can then save as one and open the other to copy data across.
As an added bonus if there is an easy way of copying the content of a csv into a tab in the excel workbook (other than select copy & paste) that would be great.
Apologies if this is answered elsewhere - I did a quick search, but couldnt find anything obvious
thanks