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