• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

7. External Programs and Data > 71. Write VBA with the Macro Recorder in Word a...

Write VBA with the Macro Recorder in Word and Excel

Take advantage of autogenerated code to speed up your coding efforts.

Let’s say you need to work with Word or Excel from within Access. And let’s say the project involves writing VBA for Word or Excel that will be used from Access via automation. Well, you don’t have to climb as steep a learning curve as you might think. That’s because both Word and Excel can generate VBA code automatically.

To make this work, you first turn on the Macro Recorder, perform certain actions in the application, and then stop the recorder. Just select Tools Macro Record New Macro to start the recorder, as shown in Figure 7-51.

Starting to record an Excel macro
Figure 7-51. Starting to record an Excel macro

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint