Dear bigwheel:

Thanks for your reply. Yes, our accounting software always create the
workbook for the invoice data under a default path with the same file name.
We did think of saving different batches of invoice data (e.g. urgent and
non-urgent ones for the day) under separate workbook names. However, if we
have, say, 5 batches for the day, we would have saved 5 different workbooks
for that day and because we keep such workbooks for months for future
reference; over time, the number of workbooks will be too many.
The other alternative is, of course, we can copy the worksheets from the
earlier 4 workbooks into the 5th (last) workbook and rename all the
worksheets 1 to 4 plus the existing worksheet 5 and all the invoices will be
within the same workbook. However, this will involve so many "copy and
paste" function.


This is why we hope to find a solution to be able to save all invoices in
one workbook with the least effort. It certainly sounds like Excel is unable
to direct the saving of data to a particular worksheet within a workbook, as
long as the same workbook name is used for saving data, all the worksheets
within that workbook will always get overwritten.

"bigwheel" wrote:


Does you accounting software always create the workbook with the same
name? From your explanation, it would appear to be the case as you say
that later downloads of data overwrite the earlier stuff. Creating
separate worksheets would not help in this case as the workbook would
get overwritten as before. Why not rename the worksheet each time the
accounting software generates the data then you will have copies of all
the invoices.


--
bigwheel
------------------------------------------------------------------------
bigwheel's Profile: http://www.excelforum.com/member.php...o&userid=25301
View this thread: http://www.excelforum.com/showthread...hreadid=397486