My bank supports an export account data to a comma separated values (csv)
file. I use this export capability for 3 checking accounts. I let it save
the csv files to the same export.csv file in the default download location.
I then have an Excel spreadsheet in which I configured to retreive the csv
data from an external file. As it sounds, this is done from the 2003 Data
menu or the 2007 Data lower ribbon. I then load the external data from this
file. Once the data link is set, pressing Alt + F5 will bring up a security
dialog asking if you want to update the data from this file. I press the Up
Arrow once and press Space to activate the Ok buttonb. This spreadsheet can
then be modified to automatically announce column and row titles, and set
column widths and formats to suit your desires. You could even hide
unwanted columns if necessary.
Once the format is what I want, I go to the first cell with Control + Home,
select all of the cells with Control + a, and press the Applications key for
a context menu and hit Enter on the "Clear contents" item. Then I save this
spreadsheet near my checkbook spreadsheet files. Thereafter, I open this
spreadsheet, which looks empty, then press Alt + F5, then Up Arrow and hit
Space to get a well formatted version of the export file!
Note, I am sure it is possible to eliminate the security alert and make the
update to the external csv file completely automatic, but I have not
bothered.
Don Marang
There is just so much stuff in the world that, to me, is devoid of any real
substance, value, and content that I just try to make sure that I am working
on things that matter.
Dean Kamen
--------------------------------------------------
From: "David Ferrin" <[email protected]>
Sent: Sunday, October 17, 2010 11:00 AM
To: <[email protected]>
Subject: [Blind-Computing] daily tip
There hasn't been one for several days because nothing seemed good to
post, hopefully this tip passes muster.
***
Open Finance Data In Excel 2007
In many cases, online banks and finance programs save data in the .CSV
(comma separated value) format. To open a .CSV file in
Excel, you'll need to save the file to your hard drive, open Excel, click
the Office button, select Open, and click the Text
Files (*.txt, *.prn, *.csv) option from the drop-down menu. Note that you
may still need to adjust the width of the columns
to fit the data.
David Ferrin
www.jaws-users.com
Life is what happens after you have already made other plans.
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
