Jump to content
Compatible Support Forums
Sign in to follow this  

how to run VBA macros of MSExcel in Linux

Recommended Posts

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.


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this