Hi - am hoping that someone can help out with this one.
I have a proforma workbook (referral form) that has a macro button that
saves into another workbook using cell references as the new workbook name
eg. Tom 1-Nov-08. The referral form then closes and the new worksheet stays
open.
The user will contiue entering data into the new workbook. The problem is
that there is another macro that copies and pastes data to a 'dump' file,
however this macro refers to the 'referral form' as the source workbook. I
will be creating new workbooks all the time from the 'referral form' all with
different workbook names.
I don't want to use the Personal.xls as several users will be using the
workbooks and they could be from different PCs.
Is there an active worksheet reference that I could use.
Hope this is clear. Using Excel 2003.