download info from bank to same file

[Jacob]

I am downloading from my bank (Scotiabank) to an Excel file, is there any
way to download the next day to the same file, so I will not need to cut and
paste?

 

[glen.e.mettler]

I am downloading from my bank (Scotiabank) to an Excel file, is there any
way to download the next day to the same file, so I will not need to cut and
paste?

There are probably many ways to do it, but I have done it this way with
good success.
1 - Download your bank data to a text file in column the format you
want and save it as Scotiabank.txt
2 - Open an Excel workbook and select Data, Import External Data,
Import and find the Scotiabank.txt file
3 - Select A2 as your import cell (this will allow you to use row 1 as
a header row for column descriptions.
4 - Insert your column headings and format the data as appropriate
(colors, date etc.)
5 - Save the file with an appropriate name (like Scotiabank
1.11.07.xls)
6 - The next time you download Scotiabank data, save it with the exact
same name (Scotiabank.txt.
7 - Open Scotiabank 1.11.07 and select Data, Refresh data - the new
data will automatically be updated.
8 - Save this file as Scotiabank 1.12.07 - this will keep an audit
trail of your data.

I hope this is what you were looking for.

Glen

 

[Jacob]

Thank you for your time and effort. I tried it but when I download to the
same text file it overwites the file and when i refresh in Excel it erases
the old info. My goal is to add the new info not to replace it.