Jump to content


Photo

how to run VBA macros of MSExcel in Linux


  • Please log in to reply
1 reply to this topic

#1 sailu_mvn

sailu_mvn

    stranger

  • Members
  • 2 posts

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 M[censored]cel 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

#2 danleff

danleff

    Carpal Tunnel

  • Moderators
  • 2903 posts

Posted 13 July 2006 - 04:40 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

IPB Skin By Virteq