Working 64 bit Excel add in, to query *.mny files?

[Trekking Tracey]

Hi

Can anyone point me to a working 64 bit Excel add in, (like Money Link Plus) to query mny files? 

Thanks

[joe dempsey]

Does Moneylink not work?

It is mostly written in VB as far as I can see

[Dick Watson]

MoneyLink has a small handler on the Excel VBA side of things, but it is, in turn, dependent upon a 32-bit DLL, source code and language unknown.

Near as I can tell, the DLL was Microsoft's contribution, at least originally, because it is a separation layer between the internal schema of the .MNY file which changed from version to verion and that which the VBA knows about which didn't. It's the 32-bit DLL that breaks in Excel 64-bit.

[Dick Watson]

I can't point you to one.

But I have one working for me that I built in VS22(VB+VSTO). It's only been tested in my environment (Exxcel 64-bit from Microsoft 365) and with my data and some specifically populated .MNY files. It has, and this is key, only been tested with US M08 Deluxe Sunset data files. It is designed to be compatible with existing .XLSX MoneyLink queries as well as to offer some optional use enhanced features above the original MoneyLink, but those ranges/queries end up unusable backwards. According to Microsoft, the APIs used limit it to Excel 2010 and up, but I have no test data outside of the Microsoft 365 Excel world. It provides comparable APi capabilities in VBA to MoneyLink. I have a sample .XLSX file demonstrating this as well as demonstrating the queries as compared to MoneyLink output--generated back when I had 32-bit Excel.

installed prerequisites include Java runtime and Hung Le's Sunriise Export tool.

It is not really documented, or at least the documents I've made are unfinished, nor is it highly polished--for instance, the toolbar has no pretty icons. I also have never paid for a signing certificate--never had a reason to or way to pay for--so this greatly complicates distributing it to others.

I will attach a .PDF of the one user doc that exists.

If all of that doesn't scare you off, contact me outside this channel, let me know what your environment is, and perhaps we can make something work to get it to you.

I had posted about this here many moons ago but got zero interest in response. Given that, my interest in packaging it all up for wider distribution waned about the time I got it all "good enough" for my use. I'd even started fleshing out a webpage for it. (http://littlegreengecko.com/MSMstuff/myMoneydata.html, FWIW.)

Dick

[Trekking Tracey]

Thank you Dick and Joe for replying - much appreciated!

Joe - I'm running 62 bit everything without access to 32 bit and receiving errors referencing this in Office 365 Excel.

Wow Dick - I am not that technical and so after digesting your pdf, will take another path....

Once again - thank you for your time taken to reply.

[First Last]

Alternate path, export your money data into CSV files (https://bitbucket.org/hleofxquotesteam/dist-sunriise/wiki/Home)

then open those CSV files in Excel.

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/a507b761-7b38-4202-8a5f-76907167086dn%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dick Watson]

Another alternate, suitable for some cases but not for others, is to create a report in Money that has what you want and then use Money's Export to Excel (.CSV, really) feature.

I really wish there was a better answer. (For both of us.) Two things prevent my solution from being more straightforward for you: 1) I've not found a way to get the data directly from the .MNY file with available VS APIs (I use DAO but it wants a .MDB, thus I use the Jave stuff to get that from the .MNY), and 2) Excel Add-Ins installed from the Web have to be signed.

[First Last]

A few years back I started some codes on providing an odata service from sunriise but then moved on to other tasks. I could resume it if there is interest.

General idea is that it will work similar to MoneyLink

* From Excel, you create a data source pointing to an URL of the odata data source. Excel will fetch the data and populate the rows/columns

* The URL could look something like this http://localhost:8080/money.svc/Accounts to get a list of accounts. Or http://localhost:8080/money.svc/Accounts(name='Checking') to get data for account with name Checking. The  query scheme a standard defined by odata (https://www.odata.org/)

* The data source will be a java program from the sunriise suite that can read the *.mny file and also know how to answer the odata query from Excel

Reference

  * How to connect Excel to an odata data source: https://kb.blackbaud.com/knowledgebase/Article/111883

  * odata: https://www.odata.org/

My email hleofxquotes at gmail dot com

[Dave Whitehead]

I use sunriise export tool, I output the raw csv files but looking to switch to the basic csv files at some point just need to spend some time analysing the basic outputs.  Only thing I've noticed is if you have notes with comma's / double quotes can offset the csv column positions, fortunately I only had a couple of note entries to alter in MS Money.  I'm converting the csv into delta files so I can have some control over datatype and query using sql and pyspark.

export.csv = raw

export.csv2 = basic

java -jar sunriise-export-0.0.2-SNAPSHOT-exec.jar export.csv moneyfile.mny password outputFolder

java -jar sunriise-export-0.0.2-SNAPSHOT-exec.jar export.csv2 moneyfile.mny password outputFolder