Hi :) Macros in LibreOffice/OpenOffice are written in a very much different format than the Excel ones. Excel macros have been know to spread malware and some offices disable them by default.
Regards from Tom :) ________________________________ From: 4logon <[email protected]> To: [email protected] Sent: Thu, 3 February, 2011 21:36:40 Subject: [libreoffice-users] Calc - Basic: VBA ActiveSheet errors after saving xls to *.ods hi, i have a small Excel sheet with a simple VBA makro inside. If I execute it with Libre-Calc everything works fine... . When I save the Excel file as LibreOffice File *.ods the VBA script failed at the line: .. Set tmpTable = ActiveSheet or workSheetName = ActiveSheet.Name ... I think this is a BUG!!!- ActiveSheet is no longer present after saving Excel file to LibreOfficeCalc file!!! Any idea??? code: Option VBASupport 1 Sub Main Dim workSheetName As String workSheetName = ActiveSheet.Name ' and do on.. End Sub -- View this message in context: http://nabble.documentfoundation.org/Calc-Basic-VBA-ActiveSheet-errors-after-saving-xls-to-ods-tp2418343p2418343.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
