Sir Babydum GBE
07-31-2007, 09:57 AM
One last question (for now - I think)
Based on a list of names on the sheet "Agents" I want to run a macro that will cause the workbook to duplicate itself as many times as there are names on the list, and to call each new workbook by the name and tomorrow's date (yyyy mm dd) (e.g. filename for me might be "2007 08 01 Sir BD").
Actually - Ideally I'd like to choose the date of the new batch of workbooks in case I want to create Monday's batch on a Friday - for example - but no big deal if not possible.
If you can help or point me in the right direction, I'd be most grateful.
Sir BD
Based on a list of names on the sheet "Agents" I want to run a macro that will cause the workbook to duplicate itself as many times as there are names on the list, and to call each new workbook by the name and tomorrow's date (yyyy mm dd) (e.g. filename for me might be "2007 08 01 Sir BD").
Actually - Ideally I'd like to choose the date of the new batch of workbooks in case I want to create Monday's batch on a Friday - for example - but no big deal if not possible.
If you can help or point me in the right direction, I'd be most grateful.
Sir BD