Hello
I'm new to Macros and I've been trying without any success to create a 'save as' macro in Excel. I have two columns of data, column A contains the file name I would like to create and column B contains the actual file contents. I have over 1,000 cells I would like to create separate text files for and save all in one folder.
I would be so grateful if someone could assist?
Thank you
I'm new to Macros and I've been trying without any success to create a 'save as' macro in Excel. I have two columns of data, column A contains the file name I would like to create and column B contains the actual file contents. I have over 1,000 cells I would like to create separate text files for and save all in one folder.
I would be so grateful if someone could assist?
Thank you