PDA

View Full Version : Sleeper: Simple problem



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

Kenneth Hobs
06-21-2011, 02:25 PM
You will need some specific criteria to set a path. It could be ThisWorkbook.Path or from an InputBox, cell, or whatever but you must be able to apply logic to determine it to make any progress on your project.

CatDaddy
06-21-2011, 02:27 PM
You will need some specific criteria to set a path. It could be ThisWorkbook.Path or from an InputBox, cell, or whatever but you must be able to apply logic to determine it to make any progress on your project.

i dont really understand what you mean, i can pick an arbitrary destination for the workbooks but im not sure about the syntax on doing that