CatDaddy
06-21-2011, 10:15 AM
WB1.Activate
WB1.Sheets(Sheets.Count).Move
After my macro is finished i have this in a for loop to go through each of the sheets in the current workbook and making it its own new workbook, the problem is i want to be able to reference these workbooks (either by saving them or making them Dim) but im not sure what the best way to do that would be if i dont have a destination that i want this to always save to...
thanks
alex
WB1.Sheets(Sheets.Count).Move
After my macro is finished i have this in a for loop to go through each of the sheets in the current workbook and making it its own new workbook, the problem is i want to be able to reference these workbooks (either by saving them or making them Dim) but im not sure what the best way to do that would be if i dont have a destination that i want this to always save to...
thanks
alex