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 4lo...@mailinator.com
To: users@libreoffice.org
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 users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***