The US Federal Reserve has banks using a macro-laden Excel spreadsheet for submitting Canadian Cash Letters.
http://www.frbservices.org/files/forms/ ... nadian.xls
I would love to convert this spreadsheet to work in Open Office but do not have the expertise. I am looking for help and am willing to pay if the cost is reasonable.
- Eli
Need help converting Excel macros to OpenOffice Calc
-
- Posts: 4
- Joined: Wed Jul 02, 2008 6:34 pm
Need help converting Excel macros to OpenOffice Calc
OOo 2.4.X on Ms Windows XP
Re: Need help converting Excel macros to OpenOffice Calc
Stay with Excel. Anything else would be hazardous, expensive and frustrating. Macros cause a vendor lock-in. Why exchange one lock-in with another?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Wed Jul 02, 2008 6:34 pm
Re: Need help converting Excel macros to OpenOffice Calc
I agree with your statement completely:
Macros cause a vendor lock-in. Why exchange one lock-in with another?
Internally we do not use Macros in order to maintain portability between applications. However, you can see that this is a form required for our business that is provided by the Federal Reserve. For this one exception I would prefer to have an Open Office solution rather than purchase 20+ licenses of Microsoft Excel.
Macros cause a vendor lock-in. Why exchange one lock-in with another?
Internally we do not use Macros in order to maintain portability between applications. However, you can see that this is a form required for our business that is provided by the Federal Reserve. For this one exception I would prefer to have an Open Office solution rather than purchase 20+ licenses of Microsoft Excel.
OOo 2.4.X on Ms Windows XP
- Hagar Delest
- Moderator
- Posts: 32658
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Need help converting Excel macros to OpenOffice Calc
Some hints here: [Solved] OO 2.4 Calc Compatibility problem with MS Excelelitomlinson wrote:I am looking for help
See in that section of the forum: Paid support.elitomlinson wrote:am willing to pay if the cost is reasonable.
Good luck.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Need help converting Excel macros to OpenOffice Calc
Well, it's in the nature of macros to be compatible with the underlying application only (Excel in this particular case). Furthermore, Excel is compatible with the Windows operating system only. When someone decided to write a particular software as Excel macro, he or she decided to use Excel, assuming that Excel is "standard" for the time running that macro.Internally we do not use Macros in order to maintain portability between applications.
You need the expertise to understand every detail of the VBA program in Excel before you can start rewriting a similar thing for another application.I would love to convert this spreadsheet to work in Open Office but do not have the expertise.
Is this the only thing that binds you to MSOffice? Then it may be reasonable to pay someone for the transition.
What tells you that they will accept your self-made Calc sheets with StarBasic macros?The US Federal Reserve has banks using a macro-laden Excel spreadsheet for submitting Canadian Cash Letters.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Wed Jul 02, 2008 6:34 pm
Re: Need help converting Excel macros to OpenOffice Calc
I will pursue this in the Paid Support forum.
Because they are only looking for the printed output from the spreadsheet.What tells you that they will accept your self-made Calc sheets with StarBasic macros?
OOo 2.4.X on Ms Windows XP