98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macro Recording
Macro Recording
Resolved · Medium Priority · Version 2003
Johsua has attended:
Excel Advanced course
Macro Recording
If I wished to get a Macro to perform a repeated action, such as within a workbook I wish it to Update the data in all the Pivot Tables in sequence, how do I script it to not end until all tables have been modified, and also how does one get it to realise where all the Pivot tables are in the workbook. Also is this the same process for Office programs such as Powerpoint and Access, or are they scripted in a different maner?
RE: Macro Recording
Hi Joshua
Thanks for your post.
Visual Basic for Applications (VBA) can be written to work with all MS Office applications (2003 or earlier, in 2007, not PowerPoint), with coding being the same except for slight modification depending on the which application you are working in.
By the brief you have we may be able to assist with consultancy.
3 steps to organising consultancy
1) email us some examples of your work, and list your key objectives). we will then profile & review your requirements
2) We will then send you a proposal
- Scope of work
- Timeframes
- Pricing
3) Sign our consultancy agreement
If you wish to progress this then please let us know.
Regards
Jacob
Training information:
- Excel 2003 visual basic intermediate course
- Microsoft excel training
- Microsoft Excel Training London
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Autonumber in ExcelTo create an autonumber field, can use the Offset() function. |