vba stopped working

Asked by David Farrier on 2010-05-11

A few days ago I upgraded to Ubuntu 10.04. I wish I hadn't! I have now discovered that vba macros in Open Office Calc have stopped working.

To enable VBA in OO, I had included the command

VBASupport 1

This worked OK in earlier versions. I have also checked

Tools > Options > Load/Save > VBA properties

and everything is ticked

As an example of the error I am getting

a=Worksheets("Sheet1").Cells(Row,1)

gives an error “Basic runtime error. '35' Worksheets”

I have searched the web, and I believe Ubuntu 10.04 includes Go-OO, which should have VBA support. I have installed Go-OO as per the Go-OO site instructions.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2010-05-11
Last reply:
2011-12-11

David Farrier, thank you for asking this and helping make Ubuntu better. However, there are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

Please test for this problem in LibreOffice. If using Lucid or Maverick feel free to type at the Terminal:

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice

For more on LibreOffice installation, please see https://wiki.ubuntu.com/LibreOffice .

Can you help with this problem?

Provide an answer of your own, or ask David Farrier for more information if necessary.

To post a message you must log in.