1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Macro needs to work in Open office ir Similar

Discussion in 'Business Applications' started by JPLamb, Nov 1, 2011.

Thread Status:
Not open for further replies.
  1. JPLamb

    JPLamb Thread Starter

    Joined:
    Jan 27, 2005
    Messages:
    577
    Hi All,

    on this occasion Google has not provided me with the answers i am looking for.

    I have got an excel macro that i have sent out to a number of people, for those who use excel it is fine but i am needing it to work in open office or similar open source free program for the few that dont have access to MS Office.

    I know that the coding is different and after the research i have done it seems that there are extentions or converters that make the VBA code work in Open office.

    Does anybody know how i can get this to work? I can not find the extentions but am told they exist.

    Any help would be really great

    Cheers
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Google is a wonderfull search tool, have you tried it? ;)
    I found the link below that opens a pdf file with the nice sounding name: "Porting Excel/VBA to Calc/StarBasic"
    http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf

    I think this is what you need.

    ...but there is more

    http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

    Happy coding :)

    BTW this is what the Open Office site claims:

    VBA Support

     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1024948

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice