Excel VBA compatibilty???

Discussion in 'Mac Apps and Mac App Store' started by David_be, Oct 6, 2003.

  1. David_be macrumors newbie

    Joined:
    Oct 6, 2003
    Location:
    Tournai, Belgium
    #1
    I have some problem to use on my mac excel vba applications (.xls) made on windows.

    IS it compatible and if not, Does a solution exist.

    ps: if it is not compatible, why Microsoft make Office for Mac???

    Yours,
    David Descamps
     
  2. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #2
    It should be compatible--only very specific types of functions are not cross-platform. What is the problem?
     
  3. Kwyjibo macrumors 68040

    Kwyjibo

    Joined:
    Nov 5, 2002
    #3
    My computer science for non-techinical majors is starting macros and VBA's soon.... so I'm hopign i'll be able to use my mac like I did for the SQL stuff
     
  4. encro macrumors 6502

    encro

    Joined:
    May 6, 2002
    Location:
    bendigo.victoria.au
    #4
    Using v.X should be fine for templates/macros. I just completed my module; in fact some of the generated VBA code on the mac is cleaner than on Office XP.
     
  5. Pexy macrumors newbie

    Joined:
    Oct 7, 2003
    Location:
    Berlin, Germany
    #5
    Basically, it works. I often exchange Excel files with VBA between my Mac and the PC at work. I always have error messages when using specific commands from the analysis add-ins, because the network installation of Office at work is mixed German/English; but this problem I have as well with the VBA macros from Office97 which we used before.

    So what specific error messages do you get, and where in the code?

    Also it would be helpful to know with version you use on both sides.

    Pexy
     
  6. David_be thread starter macrumors newbie

    Joined:
    Oct 6, 2003
    Location:
    Tournai, Belgium
    #6
    Excel 2000 on Windows:

    example:

    Cells.Find(What:=valeur_a_mod, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
    xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
    False).Activate

    Excel v.X on Mac

    example:

    Cells.Find What:="", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
    xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
    False, Activate:=True


    Quite different isn't it? :confused: i've too problems with listbox: no rowsource anymore in properties. :(


    And I've had a problem with a message when i was trying to open .xls files with macros in: "Object library not registered

    but I get ride of it with a hint at:

    http://www.macosxhints.com/article.php?story=20021115060129655
     
  7. callan macrumors newbie

    Joined:
    Aug 23, 2005
    Location:
    Leicester UK
    #7
    .dll files

    I have problems with some VBA add ins that have been compiled such that they use .dll files, and therefore dont work on EXCEL vX. I dont know whether this is solved in anyway using EXCEL 2004 but at the mo Im having to use Virtual PC with EXCEL to run these macros.

    Annoying? YES!! :mad:
     

Share This Page