How can I create a macro in Excel 2008

[jmlope]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi, I come from Windows and Excel 2007, and cannot find the possibility to create a new macro in Excel 2008 (save macro in Excel for Pc). When I go to Macros in the Tools menu only can run but not save. Is it normal?
Thanks in advance,
Jose

 

[CyberTaz]

"Normal"? Well, that's not exactly the word most would use, but it is
"true" Office 2008 does not support VBA, so macros (as most folks know
them) cannot be created or run & there is no recording capability. If you're
familiar with Excel Macro Language (XLM) you can still write macros in that
language, but nothing that involves VBA. [It's scheduled to return in
version "next".]

Apple Script can also be used for much of what VBA was relied on for if
you're familiar with it, but no recorder there either.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[jmlope]

Thanks, Bob, I guess that's happening because what I was read. One more question, when you say that this capability will return in version "next", do you mean next update or next Office package? (little difference)
I hope it could be in the next update. I was seriously thinking in switching from pc to mac, but, right now, I am in the situation that the Mac OS does really well, but I cannot do the same things I did (and I need to do) with software for mac (among others, I miss very much an One Note for mac, as the possibilities I have seen are far away from the pc software capabilities).

Jose

"Normal"? Well, that's not exactly the word most would use, but it is
"true" Office 2008 does not support VBA, so macros (as most folks know
them) cannot be created or run & there is no recording capability. If you're
familiar with Excel Macro Language (XLM) you can still write macros in that
language, but nothing that involves VBA. [It's scheduled to return in
version "next".]

Apple Script can also be used for much of what VBA was relied on for if
you're familiar with it, but no recorder there either.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi, I come from Windows and Excel 2007, and cannot find the possibility to
create a new macro in Excel 2008 (save macro in Excel for Pc). When I go to
Macros in the Tools menu only can run but not save. Is it normal?
Thanks in advance,
Jose

 

[Bob Greenblatt]

Thanks, Bob, I guess that's happening because what I was read. One more
question, when you say that this capability will return in version "next", do
you mean next update or next Office package? (little difference)
I hope it could be in the next update. I was seriously thinking in switching
from pc to mac, but, right now, I am in the situation that the Mac OS does
really well, but I cannot do the same things I did (and I need to do) with
software for mac (among others, I miss very much an One Note for mac, as the
possibilities I have seen are far away from the pc software capabilities).

Jose

PMFJI, but VBA will return in the next VERSION of Office, NOT the next
update. And, One Note IS available now in Office 2008. See the Mactopia
blog.

 

[jmlope]

And I assume that next Office version will still take a while...
I have visited the Mactopia blog, but have not seen anything regarding OneNote in Office 08, could you send me the link, pls? The only I have seen in Office 08 is a note book format for Word, but, as I said before, it is far away from the features and performance of OneNote for Windows.
By the other side, is Automator a possibility to make somethink like VBA macros in Office for Windows? (I do not know anything about Automator)

Thanks again,
Jose

 

[Bob Greenblatt]

And I assume that next Office version will still take a while...
I have visited the Mactopia blog, but have not seen anything regarding OneNote
in Office 08, could you send me the link, pls? The only I have seen in Office
08 is a note book format for Word, but, as I said before, it is far away from
the features and performance of OneNote for Windows.
By the other side, is Automator a possibility to make somethink like VBA
macros in Office for Windows? (I do not know anything about Automator)

Thanks again,
Jose

OOPS, I'm sorry, it is EndNote, not one note. Go to the mactopia site,
choose Blog, and then scroll down to the July 2 posting.

Automator can automate some manual processes, but it is not a substitute for
VBA.