|
|
#1 |
|
Hyperactive Member
Join Date: Aug 01
Location: Austin
Posts: 395
![]() |
Re: [FAQ's: OD] How do I record a macro?
any way to do this in PowerPoint 2007?
|
|
|
|
|
|
#2 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: [FAQ's: OD] How do I record a macro?
Split from FAQ item - http://www.vbforums.com/showthread.php?t=402032
AFAIK, there is no way to record a macro in PowerPoint but if there is something you need code help with, just post the question as we may be able to help you with it.
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#3 |
|
Lively Member
Join Date: Jul 02
Posts: 78
![]() |
Re: PowerPoint Macro Recording?
You can in fact record macros in PowerPoint - I will tell you that it is not as extensive and easy to update as macros in Word, but you can do it. I use Office 2003 and have been automating Office 2003 through VB 6.0 for 5 years now. For new procedures I start with a recorded macro and then expand on it.
I found a great document on the web that is a crosswalk of PowerPoint commands from Office 2003 and their new location in Office 2007 -- I have not made the move to 2007 yet (work has not, probably will next year). Macros are still available in PowerPoint 2007. Look at this document, page 24 for the new location of the command for recording a macro in PowerPoint: http://transition.gmu.edu/crosswalk/...0Crosswalk.pdf Good luck! |
|
|
|
|
|
#4 |
|
Comfortably Numb
Join Date: Feb 05
Location: Mumbai, India
Posts: 9,300
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
The macro recorder is not available in Microsoft Office PowerPoint 2007. Instead, you can use Visual Basic for Applications (VBA) to create or edit macros. To create or edit a macro by using Visual Basic for Applications, do the following:
On the Developer tab, in the Code group, click Macros. You can show the Developer tab if it is not available. In the Macro dialog box, in the Macro name box, type a name for the macro. In the Macro in list, click the template or the presentation that you want to store the macro in. In the Description box, type a description for the macro. Click Create to open Visual Basic for Applications. Note If you created a macro in a version of PowerPoint earlier than Office PowerPoint 2007 by using the macro reader, use Visual Basic for Applications to edit the macro. Note: One site does say that you can record a macro by accessing the "macros group" in powerpoint 2007 but I haven't yet tried it... Hope this helps...
__________________
A good excercise for the Heart is to bend down and help another up... Please Mark your Thread " '~~> If a post has helped you then Please Rate it by Clicking "Rate This Post" on the left hand side of the post! Excel Powerpoint MyGear: Sony VGN-FZ27G with a triple boot between (XP + Office 2003 + VB6), (VISTA + Office 2007 + VS2008) and (Win7 + Office 2010 + VS2010) |
|
|
|
|
|
#5 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
I dont see a "Macros Group" and there shouldnt still be a way to record. Sure you can write your won but I havent seen anything on recording.
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#6 | |
|
Comfortably Numb
Join Date: Feb 05
Location: Mumbai, India
Posts: 9,300
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Quote:
__________________
A good excercise for the Heart is to bend down and help another up... Please Mark your Thread " '~~> If a post has helped you then Please Rate it by Clicking "Rate This Post" on the left hand side of the post! Excel Powerpoint MyGear: Sony VGN-FZ27G with a triple boot between (XP + Office 2003 + VB6), (VISTA + Office 2007 + VS2008) and (Win7 + Office 2010 + VS2010) |
|
|
|
|
|
|
#7 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Oh I know you know but I didnt see where they were claiming that?
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#8 | |
|
Head Hunted
Join Date: Aug 07
Location: Australia
Posts: 3,553
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Quote:
The set of 4 Crosswalk pdf files are great for moving from Office 2003 to Office 2007. But if you look closely you will see that the ribbon image on page 24 of PowerPoint 2007 Crosswalk.pdf file is a fake one, that is the ribbon of Excel 2007. There is no Macro Recorder in PowerPoint-2007: See "What happened to the macro recorder?" from Microsoft.
__________________
• IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB • CopyFileByChunk |
|
|
|
|
|
|
#9 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Thanks for the link to back us up on not being able to record macros in 07
PP does not have a Data tab or a Formula tab as shown in that image.
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#10 | |
|
Comfortably Numb
Join Date: Feb 05
Location: Mumbai, India
Posts: 9,300
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Quote:
__________________
A good excercise for the Heart is to bend down and help another up... Please Mark your Thread " '~~> If a post has helped you then Please Rate it by Clicking "Rate This Post" on the left hand side of the post! Excel Powerpoint MyGear: Sony VGN-FZ27G with a triple boot between (XP + Office 2003 + VB6), (VISTA + Office 2007 + VS2008) and (Win7 + Office 2010 + VS2010) |
|
|
|
|
|
|
#11 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
Yea I had a second more closer look and realized like Anhn that it was not a picture of PowerPoints ribben bar but Excels.
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#12 | |
|
New Member
Join Date: Aug 08
Posts: 3
![]() |
Re: [FAQ's: OD] How do I record a macro?
Quote:
Word and Excel allow you to kick off the Macro Recorder by choosing Macros on the View tab and then clicking the Record Macros menu. The Macro Recorder exists in PowerPoint 2007 as well, but the command to start and stop the recorder has been inexplicably left off the View and Developer tabs. To record a PowerPoint macro, use the legacy keyboard commands Alt+T, M, R to start, (Tools - Macro - Record) and use the same keyboard combination to stop recording. In theory, when you turn on the macro recorder, VBA "watches" as you perform some action or series of actions. When you turn off the recorder, you can replay the resulting recorded macro to replicate that series of actions. Try it out!! |
|
|
|
|
|
|
#13 |
|
New Member
Join Date: Aug 08
Posts: 3
![]() |
Re: PowerPoint Macro Recording?
Did it work for you RobDog888??
|
|
|
|
|
|
#14 |
|
Head Hunted
Join Date: Aug 07
Location: Australia
Posts: 3,553
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
__________________
• IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB • CopyFileByChunk Last edited by anhn; Sep 5th, 2008 at 05:23 PM. |
|
|
|
|
|
#15 |
|
Super Moderator
Join Date: Apr 01
Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™
Posts: 58,848
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Re: PowerPoint Macro Recording?
@brian08, You may not want to plagerize content without stating/linking the source.
![]() No, it doesnt record simple keystrokes, at least for me typing in a title and description, and produced a blank procedure. If it works its i"in theory" but should have at least recorded simple keystrokes.
__________________
VB/Office Guru™ (AKA: Gangsta Yoda™ I dont answer coding questions via PM. Please post a thread in the appropriate forum. ![]() ![]() Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET (Internet.com's #1 Poster) If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007 |
|
|
|
|
|
#16 |
|
New Member
Join Date: Dec 08
Posts: 2
![]() |
Re: PowerPoint Macro Recording?
I also tried the keystroke recorder and only got a blank module...any ideas on how to get the name of the placeholders on the slidemaster in 2007? I have a macro that calls the placeholders in PP2003 but they have changed.
|
|
|
|
![]() |
|
||||||
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|