iPad-app to handle a workbook (and VBA) better than Excel for iPad?
Dear Expert!
I have some Excel workbooks consisting of data and Excel-functions that also relies on a substantial chunk of (identical) VBA to produce the results, and now I would like to move this into the iOS world. What thought was the obvious solution, using Excel for iPad, doesn't work since it doesn't handle any VBA and doesn't have any macro language (I also find it rather awkward to work in...)
So my question is if anyone has used a generic app for anything like this (handling Excel functions, workbooks and possibly has a macro/script language), since I prefer not to do a full App-development. Or if you have creative ideas how to solve this?
Since the question is for high-level ideas, there is no point of adding any example.
Of course I have no problem for any biased answers from developers working at the company who has an existing app for this, but I am not looking for proposals on development of an app ;-)
I have some Excel workbooks consisting of data and Excel-functions that also relies on a substantial chunk of (identical) VBA to produce the results, and now I would like to move this into the iOS world. What thought was the obvious solution, using Excel for iPad, doesn't work since it doesn't handle any VBA and doesn't have any macro language (I also find it rather awkward to work in...)
So my question is if anyone has used a generic app for anything like this (handling Excel functions, workbooks and possibly has a macro/script language), since I prefer not to do a full App-development. Or if you have creative ideas how to solve this?
Since the question is for high-level ideas, there is no point of adding any example.
Of course I have no problem for any biased answers from developers working at the company who has an existing app for this, but I am not looking for proposals on development of an app ;-)
ASKER
Hi xtermie
Thank you for an extremely rapid answer!
I need the macros (either VBA or re-coded into the app-macro-language) to execute on the iPad (or a server) for it to work, not only viewing the workbooks.
Thank you for an extremely rapid answer!
I need the macros (either VBA or re-coded into the app-macro-language) to execute on the iPad (or a server) for it to work, not only viewing the workbooks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help!
You cannot create macros with VBA in Excel Online, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file.
Also there is a company called https://www.qimacros.com that has templates with macros for ipad and the Excel app, but I have not tried it myself.