Excel Mac 2008 macros support

Discussion in 'Mac Apps and Mac App Store' started by akadmon, Jan 28, 2008.

  1. akadmon macrumors 68010

    Joined:
    Aug 30, 2006
    Location:
    New England
    #1
    I know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there?

    BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof :)
     
  2. onomatopoeia macrumors 6502

    onomatopoeia

    Joined:
    Dec 9, 2007
    #2
    Correct me if I'm wrong but I don't think simple macros require VB.
     
  3. akadmon thread starter macrumors 68010

    Joined:
    Aug 30, 2006
    Location:
    New England
    #3
    Native Excel macros require VB. You must be thinking of some keystroke sequencing programs, or perhaps Applescript.
     
  4. rsales macrumors newbie

    Joined:
    Aug 2, 2008
    #4
    So for running macros i need to use windows excel not mac excel?

    I'm going to do some vba in my classes and i have an mac, and in excel it has that option of "Macros" but it doesn't have vba, there any way of installing ?
     
  5. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #5
    Not for Excel 2008. Excel 2004 have VBA support (based on VB 5, which is the equivalent of Excel 97 on the Windows side, and that will not be sufficient for any class work).

    If you are taking VBA classes, the assumption will be that it is Windows-based and either Excel 2003 (VB 6) or Excel 2007 (.net). So you could load Boot Camp and install Windows and one of those versions.

    MS has indicated that VBA will come back to the Mac, but who knows when and in what version. And you can be sure that it will always be behind the Windows version.
     
  6. portent macrumors 6502a

    Joined:
    Feb 17, 2004
    #6
    Old-style Excel macros (Excel 5.0/95 macros) are NOT based on VB and continue to work fine in 2008.
     
  7. TroubledbyMacs macrumors newbie

    Joined:
    May 23, 2009
    #7
    Help with macros


    I just found out I cannot effectively use a critical form (riddled with macros) produced by the federal government and required for applications for grants-in fact it is required for every federal grant. Last year I could use the files, no problem--the macros worked. I have mac office 2004, which of course I have updated throughout the year as advised in those update reminders.

    Apple tech staff on my local store last night thought the updates may have been the problem, so I trashed and the reinstalled my 2004 software--still an issue.

    Does anyone know another option other than 1) buy a pc, buy windows software 2) partition mac, buy windows software 2) go to kinkos and rent a pc for two days of work (certainly not fair to borrow one for 2 days)?

    BTW--these applications are due this week
     
  8. mathcolo macrumors 6502a

    Joined:
    Sep 14, 2008
    Location:
    Massachusetts
    #8
    Correct me if I'm wrong but I do believe that the Microsoft Office 2008 suite has relatively good support for AppleScript, which takes care of the lack of support for VBA. It should work just fine for most things.

    Edit: Oops, this is a really old thread. Whatever, anyways: TroubledByMacs: If you need to use Windows software without software like Parallels Desktop or VMware Fusion, then try Crossover Mac.
     
  9. Modkoko macrumors newbie

    Joined:
    Sep 30, 2009
    #9
    Excel 2008 Questions

    How do I code AppleScript to act in place of macro in Excel 2008? For example, if I wanted to create a 'macro' like function to enter 5 rows under each row, how do I do this in Apple Script? Does anyone know of any literature or website where I can study about this more?

    Also, does Number '09 has macro or macro-like functions?
     

Share This Page