vba stopped working
Asked by
David Farrier
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(
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
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
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.