Good morning scripting experts
I've had an idea to an issue that fairly frequently arrises. We use MYOB software and receive ledgers from a range of software versions. We do have 3rd party software that helps us ascertain which version of the MYOB software we need to use to open the software. Trouble is the 3rd party software doesn't always corrently identify the version of MYOB required to open the ledger file. When this happens we then have to open all versions of MYOB sequentially and try the ledger and see if it is the correct version. Quite tedious. I have copied all MYOB application shortcuts to my desktop and can drop the ledger file onto each shortcut and see if it opens, if it does, happy days, if it doesn't then I try the next version of MYOB etc. Better but still tedious.
Soi thats the situation, how can you experts help me with scripting?
From a high level view it would be great if the script could
ask for the path to the ledger file
Try and open the 1st version of myob using the supplied ledger file
Ask the user if the ledger opened via a msgbox
If the ledger did open ok then end script otherwise try the next version of MYOB
Thanks for input on this one