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.
jb101
 
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
Moderator
 
Posts: 28545
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.
Attachments
dynValidation2.3.ods
New dynamic validation
(16.54 KiB) Downloaded 9954 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
Villeroy
Volunteer
 
Posts: 27117
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()

HTH
Cheers
Winfried

DateTime2 extension: insert date, time or timestamp, formatted to your needs
User avatar
probe1
Volunteer
 
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 5 guests