Compatible Support Forums: how to run VBA macros of MSExcel in Linux

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

how to run VBA macros of MSExcel in Linux

#1 User is offline   sailu_mvn 

  • stranger
  • Group: Members
  • Posts: 2
  • Joined: 13-July 06

Posted 13 July 2006 - 01:15 PM

The Openoffice macros are written in Star Basic language and MSOffice macros are written using Visula Basic for Applications.
I have a Excel Macro file which has to run on linux.
The following are the procedures I adapted and finally i was not able to make it.

I first tried with Openoffice and found that the way the Openoffice processes the DataSheet is different from the way the MSOffice does.

So, I have known an emulator called wine. I installed wine. Then created an windows environment and then I installed VB6 runtime environment for the VBA to work. Now, it was time for me to try my luck in wine by installing MSoffice. I installed MSoffice 97 and the installation went pretty well.

Now, when I open my Excel sheet containing macros, the MSExcel started bouncing with errors.
The error was
-------------------------------------------------- ---------------------
" Run-time error '-2147417848 (80010108)':Run-time error '-2147417848
(80010108)': Method 'Paste' of Object '_Worksheet' Not Found."
-------------------------------------------------- ---------------------

I googled and found that this error occurs when the cells are conditionally formatted and the cells range to paste was lost.

Can anyone guide me how to continue working on this?

Please advice me.
Sailaja
0

#2 User is offline   danleff 

  • Carpal Tunnel
  • Group: Moderators
  • Posts: 2903
  • Joined: 30-August 02

Posted 13 July 2006 - 04:40 PM

Looks as if this is curently being worked on. See this article.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users