G
Guest
Hi,
i have tried to do this and asked the question in General questions but to
no avail. i am looking for some help on a routine to carry out the following:
save the active sheet as a separate workbook in a specific location
the specific location is in the same folder "S:\invoices" and the folder
contains sub folders Jan to Dec.
i need the worksheet to save in this location by date and sheet/ client
name. for example:
client name = range("B23")
date = ("H14")
so my worksheet i need to save is 2945, the client name is "my client" and
the date is 23rd July 2005.
my sheet would be saved as
S:\invoices\July\2945 my client
( sheet only in a book not original book saved here)
cqan anyone help me with this as i need to close this project and i cannot
seem to get it at all.
thanks in anticipation,
Nigel
i have tried to do this and asked the question in General questions but to
no avail. i am looking for some help on a routine to carry out the following:
save the active sheet as a separate workbook in a specific location
the specific location is in the same folder "S:\invoices" and the folder
contains sub folders Jan to Dec.
i need the worksheet to save in this location by date and sheet/ client
name. for example:
client name = range("B23")
date = ("H14")
so my worksheet i need to save is 2945, the client name is "my client" and
the date is 23rd July 2005.
my sheet would be saved as
S:\invoices\July\2945 my client
( sheet only in a book not original book saved here)
cqan anyone help me with this as i need to close this project and i cannot
seem to get it at all.
thanks in anticipation,
Nigel