Re: [libreoffice-users] Calc - Basic: VBA ActiveSheet errors after saving xls to *.ods

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 <4logon@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+help@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+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***