Migrating Excel Macro

Creating a macro - Writing a Script - Using the API

Migrating Excel Macro

Postby jb101 » Tue Jan 29, 2008 7:13 am

I am trying to migrate an Excel Macro that works with a ListBox Control. The macro fails on the very first statement which is ListBox.Clear. I have not been able to find any documentation related to this. Can someone give me a pointer.
Posts: 6
Joined: Mon Jan 21, 2008 1:22 am

Re: Migrating Excel Macro

Postby Hagar Delest » Tue Jan 29, 2008 11:38 pm

Excel macros are not compatible, language is different. You should search the forum with the "Excel macro" string. Try that one: Can't run a VBA macro from MS Excel file.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Migrating Excel Macro

Postby Villeroy » Wed Jan 30, 2008 12:36 am

Since version 2.3 Calc supports dynamic validation, which may be an Excel compatible alternative to listboxes. See attachment.
New dynamic validation
(16.54 KiB) Downloaded 9946 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Posts: 27096
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Migrating Excel Macro

Postby probe1 » Wed Jan 30, 2008 12:02 pm

For examples on (OOo's) listbox handling one can have a look at Basic library "FormWizard" (delivered with a standard installation), which uses SUBs on common tasks (fill, clear, delete first entry, ...); e.g. EmptyFieldsListboxes()


DateTime2 extension: insert date, time or timestamp, formatted to your needs
User avatar
Posts: 277
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand

Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 11 guests