Macro fails on reload of spreadsheet
Enviado: 21 Jun 2018 às 08:17
Hello,
I ported a VBA macro from Excel, got it to work, and saved the spreadsheet as an OpenOffice ODS file. When I re-opened the spreadsheet, the macro gave this error:
BASIC runtime error
Sub-procedure or function procedure not defined.
on this line:
vps = Range("f6")
I see nothing wrong with the line. Here is the weird thing: If I insert a <CarrigeReturn> before the line, and then remove it, the macro runs correctly with no problem. However, if I save the spreadsheed, and re-load it, the macro fails again. If I repeat the insert and remove of the <CarriageReturn> (or any other character), the macro works again. What could cause this weird problem? How can I get the macro to work?
Please help
I didn't find the right solution from the internet.
References:
https://forum.openoffice.org/en/forum/v ... 20&t=69222
Whiteboard Video Production Company
Thank you
I ported a VBA macro from Excel, got it to work, and saved the spreadsheet as an OpenOffice ODS file. When I re-opened the spreadsheet, the macro gave this error:
BASIC runtime error
Sub-procedure or function procedure not defined.
on this line:
vps = Range("f6")
I see nothing wrong with the line. Here is the weird thing: If I insert a <CarrigeReturn> before the line, and then remove it, the macro runs correctly with no problem. However, if I save the spreadsheed, and re-load it, the macro fails again. If I repeat the insert and remove of the <CarriageReturn> (or any other character), the macro works again. What could cause this weird problem? How can I get the macro to work?
Please help
I didn't find the right solution from the internet.
References:
https://forum.openoffice.org/en/forum/v ... 20&t=69222
Whiteboard Video Production Company
Thank you