Open/Import MS Money OFX file into Excel?
in [General]
|
From: Joe User on 29 Jan 2010 04:41 Downloading data from an online banking website. Besides Quicken files (WebConnect and QIF), the only other file format is MS Money OFX. That is an ASCII format with HTML-like syntax. I am currently writing a macro to parse it. But I wonder.... Is there any way to directly input an MS Money OFX file into Excel, other than purchasing a conversion program? A Google search reveals that this question has been asked before in other forums. I did not see a usable solution.
From: Ron Rosenfeld on 29 Jan 2010 08:30 On Fri, 29 Jan 2010 01:41:19 -0800, "Joe User" <joeu2004> wrote: >Downloading data from an online banking website. Besides Quicken files >(WebConnect and QIF), the only other file format is MS Money OFX. > >That is an ASCII format with HTML-like syntax. I am currently writing a >macro to parse it. But I wonder.... > >Is there any way to directly input an MS Money OFX file into Excel, other >than purchasing a conversion program? > >A Google search reveals that this question has been asked before in other >forums. I did not see a usable solution. Well, I see there is a free ofx2csv converter available: http://www.softpedia.com/get/Office-tools/Other-Office-Tools/OFX2CSV.shtml --ron
From: Joe User on 29 Jan 2010 09:51 "Ron Rosenfeld" <ronrosenfeld(a)nospam.org> wrote: > Well, I see there is a free ofx2csv converter available: > http://www.softpedia.com/get/Office-tools/Other-Office-Tools/OFX2CSV.shtml Thanks. I had seen that, too; but I missed the fact that it is free and it has a seal of safety from Softpedia. What can I say: it was late; I was under pressure; I had my glassed on upside down; etc etc etc. :-) Oh well, the VBA converter was not difficult to write. And as it turns out, I am dissatisfied with the content of the OFX file; the bank omitted some important details that are visible online. So I might give the QIF format a whirl. There is some chance that the content is more complete. The bank's web page is titled "Download For Quicken". So I get the feeling that support of an MS product (namely MS Money) was an afterthought. Thanks again. ----- original message ----- "Ron Rosenfeld" <ronrosenfeld(a)nospam.org> wrote in message news:7jo5m59c2pr478d4rjnpl3b7dt6lm6s62f(a)4ax.com... > On Fri, 29 Jan 2010 01:41:19 -0800, "Joe User" <joeu2004> wrote: > >>Downloading data from an online banking website. Besides Quicken files >>(WebConnect and QIF), the only other file format is MS Money OFX. >> >>That is an ASCII format with HTML-like syntax. I am currently writing a >>macro to parse it. But I wonder.... >> >>Is there any way to directly input an MS Money OFX file into Excel, other >>than purchasing a conversion program? >> >>A Google search reveals that this question has been asked before in other >>forums. I did not see a usable solution. > > Well, I see there is a free ofx2csv converter available: > > http://www.softpedia.com/get/Office-tools/Other-Office-Tools/OFX2CSV.shtml > > --ron
From: Ron Rosenfeld on 29 Jan 2010 18:38 On Fri, 29 Jan 2010 06:51:45 -0800, "Joe User" <joeu2004> wrote: >Thanks. I had seen that, too; but I missed the fact that it is free and it >has a seal of safety from Softpedia. What can I say: it was late; I was >under pressure; I had my glassed on upside down; etc etc etc. :-) > >Oh well, the VBA converter was not difficult to write. And as it turns out, >I am dissatisfied with the content of the OFX file; the bank omitted some >important details that are visible online. > >So I might give the QIF format a whirl. There is some chance that the >content is more complete. The bank's web page is titled "Download For >Quicken". So I get the feeling that support of an MS product (namely MS >Money) was an afterthought. > >Thanks again. I suppose I'm going to have to figure out how my Money program is going to work when MS ceases all support for it. I'm not looking forward to it. But I'm hoping for a viable solution. For me, the quote download issue will be quite important. And, I'm sure, others will have other priorities. Good Luck! --ron
|
Pages: 1 Prev: Convert table to a single column Next: Counting the number of different entries in a column |