SaveAs Macro

Hello All,

My problem is that I need the macro to save files with certain file names and I have a column that has the file name but I dont know how to add that to my SaveAs step. I am also not sure how to loop through tabs... Can I use "Next"?

Currently I have one master file with approx. a thousand tabs, I want my end result to be a thousand separate excel files all saved in their own workbooks named after cell A2 in each tab is that possible?

My code is below (???? Around guesses ????) and included in the attached sample:

Please Login or Register  to view this content.