Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Office 2004 Macro help, please

Office 2004 Macro help, please
Thread Tools
Dedicated MacNNer
Join Date: Mar 2005
Status: Offline
Reply With Quote
Sep 19, 2008, 12:55 PM
 
Hi all,

I'm trying to add code to an Excel macro I made in my Office98 days. For starters, the macro was written in the old sheet-based Macro language (i.e. =WORKBOOK.ACTIVATE("compuAccessCHART",FALSE)

So, my question is, how, in Office2004, do I record a macro so that the instructions get written in the Macro spreadsheet of that Office98 sheet-based Macro language. That way, I can add the recorded code to the already created macros in the Macro sheet?
PowerBook G4 1.5 GHz/1GB RAM/OS/X (10.4.11)
Windows--A fate in league with Communism.
     
Mac Elite
Join Date: May 2001
Location: Manchester, UK
Status: Offline
Reply With Quote
Sep 19, 2008, 04:48 PM
 
You can simply record a macro in Excel 2004. I believe that Visual Basic for Applications was the same in Excel 98 and Excel 2004, so those old macros should just work in Excel 2004.
     
Dedicated MacNNer
Join Date: Mar 2005
Status: Offline
Reply With Quote
Sep 26, 2008, 11:44 AM
 
Originally Posted by philm View Post
You can simply record a macro in Excel 2004. I believe that Visual Basic for Applications was the same in Excel 98 and Excel 2004, so those old macros should just work in Excel 2004.
**Me here:

I attempted to record a new macro so I could cut/paste the code in elsewhere already but, the instructions/actions do not get recorded in the spreadsheet and not with the Excell 98 macro language. What I am trying to accomplish is to record a macro so it gets recorded and coded on my Macro sheet in the workbook in the Excel 98 macro language, not Visual Basic.
(Last edited by gulmatan; Sep 29, 2008 at 12:48 PM. )
PowerBook G4 1.5 GHz/1GB RAM/OS/X (10.4.11)
Windows--A fate in league with Communism.
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 01:11 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2