'Writing/assigning a macro using 'tools-->macros'

[HansHans]

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

Dear all,

I'm fairly new to Excel 2008 for Mac but I remember that I read somewhere that it is possible to write a macro on a separate page of a workbook and assign and run it from the tools-->macros dialogue.

However, on that window I cannot name the macro nor point to it nor run it. The only option available is "cancel".

Is my memory wrong or what am I doing wrong?

Thank you very much for any help.

Hans

 

[Phillip Jones]

VBA is totally missing from Office2008 and therefore no macros work
except some supposedly designed without the aid of VBA.

Now Office2007 of PC is able to. and Office 2004 is able to.

MS and The Mac Unit got such an earful from College, and Universities;
students and professors alike They will definitely install it back in
next version. whenever that is. last update cycle for both PC and Mac
was 4 years. Though they are supposed to be on a two year track. so who
knows. In any event Nurse your copy of 2004 along on the Intel machines.
As OSX continues to change there will be a point where 2004 doesn't
work. Let us hope that that point is much later.

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

Dear all,

I'm fairly new to Excel 2008 for Mac but I remember that I read somewhere that it is possible to write a macro on a separate page of a workbook and assign and run it from the tools-->macros dialogue.

However, on that window I cannot name the macro nor point to it nor run it. The only option available is "cancel".

Is my memory wrong or what am I doing wrong?

Thank you very much for any help.

Hans

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[HansHans]

Thanks Phillip,

well I know VBA is not available but "tools-->macros" and a macro screen with a "run" button suggest that there is some way of defining something like a macro.

While reading your reply and thinking hard about what I seemed to have read a while ago I suddenly remembered what I did. You inspired me.

You can insert a "macro page" into a workbook (insert-->sheet-->other=Internal macro sheet from the box in the middle) and there you can write macro code. On the "tools-->macros" screen click the icon at the very right edge of the "macro name" field and highlight the cells that contain the code. Then click "run".

I haven't got to the bottom of the possibilities but this is the way to investigate further.

Thanks again for your reply.
Best regards

Hans

 

[CyberTaz]

Hello Hans -

You're on the right track. Even though 2008 doesn't support VBA it does
still support XLM - Excel Macro Language. I've been away from it for years
so I can't offer much insight, but there are a few others who frequent this
group who are quite expert at it... And you might also try Google.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac

 

[HansHans]

Thanks Bob,

it'll be fun to find out how it works. Excel is still the best spreadsheet program and macros can make your life a lot easier.

Currently it lets me enter a macro but when I "step through" it, it goes through all the code but doesn't do anything and at the end it says "no return() or halt()".

I'll try Google as you suggested.

Should an expert read this post ... any hints are more than welcome. Might save me a lot of reading and trying.

Have a great weekend.

Best regards
Hans

 

[Jim Gordon MVP]

Thanks Phillip,

well I know VBA is not available but "tools-->macros" and a macro screen with a "run" button suggest that there is some way of defining something like a macro.

While reading your reply and thinking hard about what I seemed to have read a while ago I suddenly remembered what I did. You inspired me.

You can insert a "macro page" into a workbook (insert-->sheet-->other=Internal macro sheet from the box in the middle) and there you can write macro code. On the "tools-->macros" screen click the icon at the very right edge of the "macro name" field and highlight the cells that contain the code. Then click "run".

I haven't got to the bottom of the possibilities but this is the way to investigate further.

Thanks again for your reply.
Best regards

Hans

Hi

In Excel 2008 click the help button on the standard toolbar to activate
Excel help (or use the help menu)

Search on the term
xlm

There's a help topic about excel 4.0 macros. In that help topic is a
link to the Microsoft web site.

Click that link to download the XLM macro language documentation.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[HansHans]

There's a help topic about excel 4.0 macros. In that help topic is a

link to the Microsoft web site.

Thanks Jim,

That was a very helpful hint. Gives me a lot to read but also a big opportunity to improve.

Best regards
Hans

 

[Bob Greenblatt]

Thanks Jim,

That was a very helpful hint. Gives me a lot to read but also a big
opportunity to improve.

Best regards
Hans

Hans,

If you get that error it is really due to the fact that there is no return
statement. Make sure there is an =return() at the end of your macro. Feel
free to post the macro code here for additional help.

 

[HansHans]

If you get that error it is really due to the fact that there is no return

statement. Make sure there is an =return() at the end of your macro. Feel
free to post the macro code here for additional help.

Hi Bob,

Unfortunately I am not really familiar with that macro language. I am fairly familiar with VBA but for the XLM language I need to find some piece of basic level introduction that enables me to do some testing.

I tried something like

[a10]=123456
=return()

When I run that it does not give an error message but it doesn't do anything, visibly.

So, as soon as I find some documentation about the language structure itself I'll carry on testing.

In the meantime thanks to all for your time and valuable advice.

Best regards
Hans

 

[Bob Greenblatt]

If you get that error it is really due to the fact that there is no return
statement. Make sure there is an =return() at the end of your macro. Feel
free to post the macro code here for additional help.

Hi Bob,

Unfortunately I am not really familiar with that macro language. I am fairly
familiar with VBA but for the XLM language I need to find some piece of basic
level introduction that enables me to do some testing.

I tried something like

[a10]=123456
=return()

When I run that it does not give an error message but it doesn't do anything,
visibly.

So, as soon as I find some documentation about the language structure itself
I'll carry on testing.

In the meantime thanks to all for your time and valuable advice.

Best regards
Hans

The only documentation on the XLM macro language is at least 10 years old,
if you can find it. We can help, but you need to describe what you are
trying to do. I assume from your example, you'd like to place the value
123456 into cell A10 of the active sheet. The xlm macro code to do this is:
=formula(123456,!a10)
=return()

 

[HansHans]

The only documentation on the XLM macro language is at least 10 years old,

if you can find it. We can help, but you need to describe what you are
trying to do. I assume from your example, you'd like to place the value
123456 into cell A10 of the active sheet. The xlm macro code to do this is:
=formula(123456,!a10)
=return()

Thanks Bob,

Well, I do not have an actual problem. As I said before I am new to the Mac and new to Office 2008 for Mac. I just want to be prepared for the time when I do have an actual problem.

So this is more or less trying to collect whatever I can get to familiarize with the XLM macro language.

Your advice for the formula was very helpful and it helps me to proceed. Should I have further problems/questions I would post them here and I would be grateful for your advice.

Best regards
Hans