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 ***
