![]() ![]() Private Sub Workbook_Open - that looks like VBA, not OpenOffice Basic.įor an introduction to OpenOffice macros with many excellent examples, see Andrew Pitonyak's Macro Document.What is $1? Perhaps you mean a range like "$A1:$A5".ByName(("B10")) - too many parentheses, and again, there is no such method as "ByName".ActiveSheet.getcell - I am not aware of any such method.Dim oSheet as Object - but n was never declared or defined.It says "ThisComponent.CurrentController" twice.You need to press Enter to add several line breaks. ActiveSheet.getcellDim oSheet as ObjectoSheet = ($1)ByName(("B10")).Value = "My Current Time of the System:" It looks like there are a number of issues with this code. This line of code causes the syntax error is : .ActiveSheet.getCellDim oSheet as ObjectoSheet = ($1)ByName(("B10")).Value = "My Current Time of the System:" ActiveSheet.getCellDim oSheet as ObjectoSheet = ($1)ByName(("C10")).Value = Format(Now, "hh:mm:ss AM/PM") ActiveSheet.getCellDim oSheet as ObjectoSheet = ($1)ByName(("B10")).Value = "My Current Time of the System:" I tried convert this macro to OpenOffice macro (using ) Private Sub Workbook_Open() Range("C10").Value = Format(Now, "hh:mm:ss AM/PM") Range("B10").Value = "My Current Time of the System:" Private Sub Workbook_Open()Īpplication.OnTime Now + TimeValue("00:00:05"), "RefreshTime" Here is macro for refresh in every 5 seconds. How to port Excel VBA macro to OpenOffice basic macro? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |