Excel User Defined Functions

Discussion in 'Mac Apps and Mac App Store' started by amusmani, Oct 22, 2011.

Most Liked Posts
  1. amusmani, Oct 22, 2011

    amusmani macrumors newbie

    Joined:
    Oct 22, 2011
    #1
    Hi,

    I am having problems using an excel sheet that has a lot of VBA code and contains user defined functions. I have MS Office 2011 so the VBA is supposed to work. The workbook and functions works perfectly with a windows computer but when I use it on my Mac "VALUE" just shows up the cell.

    Excel recognizes that the function exists and also lists the inputs for the function but it cannot evaluate it. I would appreciate any advice.
     
    share
    + Quote Reply
  2. pilotError, Oct 23, 2011

    pilotError macrumors 68020

    pilotError

    Joined:
    Apr 12, 2006
    Location:
    Long Island
    #2
    One of the members of the Mac Office team frequents this site. Search for Mac Office and you should be able to find her user id. I'm not sure if she follows the programming threads though.

    You may have to post in the "Mac Applications" group to catch their attention.

    Or... Wait long enough, I'm sure someone here has Excel for Mac experience.
     
    share
    + Quote Reply
  3. balamw, Oct 23, 2011

    balamw Moderator

    balamw

    Staff Member

    Joined:
    Aug 16, 2005
    Location:
    New England
    #3
    Or request that the mods move the thread there for you. ;) I left a link from the programming forum just in case.

    B
     
    share
    + Quote Reply
  4. MisterMe, Oct 23, 2011

    MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #4
    We would have to see the code to diagnose the error. One thing to look out for is that the code may explicitly assume the Windows file system. MacOS X does not use the Windows file system. Also, VBA on the Mac does not have the run of the System. It is sandboxed to Office 2011.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page