Just recently upgraded from v19 to 2013.3. Not very happy with the export to Excel formatting at all. I now have to reformat all the exported reports as the numbers come through as text, not numbers....
Hi EdenInOz
In order to connect to an online file through API, you would be best checking out our great Developer site - http://developer.myob.com
The first step will be to sign up to our Developer program so you can obtain some API keys.
As for connecting to an online file, I found some documentation here but it is of a very technical nature.
As another solution, there are some 3rd party programs such as Easydownloader that can download data on your behalf from a Live file to excel which may suit some users better.