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

Macros in Mac Office Excel

N

naturallight

macrumors member
Original poster
Apr 15, 2007
59
0
Hi, I searched for this but couldn't find anything.

I'm trying to set up some macros in Excel 2004. When I go to record the macro, after I type in the name of the Macro, I can't record it. The only button that I can click is "Cancel". I am not putting a space in my macro name.

Perhaps somewhat related, I can find/open my Personal Workbook. There are no hidden files. And when I try to create the Macro, the "Personal Workbook" isn't an option for where to save it.

I'm pretty familiar with the windows Excel, so this all seems kind of weird.

Can anyone help? Thanks!
 
The new office for Mac, does not have the Macros aspect. It was left out.


With Excel 2008, you can continue to use and maintain Excel 4.0 macros (XLM macros) that have not been upgraded to Visual Basic® for Applications (VBA). Although you cannot record new Excel 4.0 macros in Excel 2008, you can run and modify them.
The Excel 4.0 Macro Reference provides information including syntax and examples for the macro functions. You can find more information about the Excel 4.0 Macro Reference on the Microsoft Web site (www.microsoft.com/mac).
Click to expand...
 
iMac-Knight said:
The new office for Mac, does not have the Macros aspect. It was left out.
Click to expand...

He said specifically he was using 2004
You should be able to use macros in 2004

I don't have 2004 installed any more, so I can't look for you
But someone will be along soon to help... or you can PM nadyne the MS Office rep

Woof, Woof - Dawg
pawprint.gif
 
No, Office 2004 has macro support (based on VB 5), but Office 2008 does not have macro support. The OP stated he/she had Office 2004, so there is macro support.

I remember seeing this problem a few years ago. I will try to find the link to resolve.
 
Office:Mac 2004 does have macros support (Office 2008 doesn't; the next version of Office will bring it back). However, Office 2004 doesn't allow you to record macros. :(

One option would be to create an AppleScript instead of using VBA macros. This is a good solution if you're only working on a Mac, but won't help if you're going cross-platform. The AppleScript dictionary in Excel 2004 is pretty good; we made improvements to it in Excel 2008 to try to bridge the gap that removing VBA caused. There's a VBA to AppleScript transition guide that will help you learn how to go from VBA to AppleScript.

Regards,
Nadyne.
 
nadyne said:
Office:Mac 2004 does have macros support (Office 2008 doesn't; the next version of Office will bring it back). However, Office 2004 doesn't allow you to record macros. :(

One option would be to create an AppleScript instead of using VBA macros. This is a good solution if you're only working on a Mac, but won't help if you're going cross-platform. The AppleScript dictionary in Excel 2004 is pretty good; we made improvements to it in Excel 2008 to try to bridge the gap that removing VBA caused. There's a VBA to AppleScript transition guide that will help you learn how to go from VBA to AppleScript.

Regards,
Nadyne.
Click to expand...

But can you record AppleScript in Excel via the Script Editor? The help says "Some applications let you record actions using Script Editor". Do you know if the next Office release, with VBA, will have VBA recording (or AppleScript recording)?
 
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