Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Excel Mac 2008 macros support

A

akadmon

Suspended
Original poster
Aug 30, 2006
2,006
2
New England
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 :)
 
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 ?
 
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.
 
akadmon said:
Native Excel macros require VB. You must be thinking of some keystroke sequencing programs, or perhaps Applescript.
Click to expand...

Old-style Excel macros (Excel 5.0/95 macros) are NOT based on VB and continue to work fine in 2008.
 
Help with macros

portent said:
Old-style Excel macros (Excel 5.0/95 macros) are NOT based on VB and continue to work fine in 2008.
Click to expand...


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
 
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.
 
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?
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back