Access.2007.VBA.Bibl..

FIGURE 12.8

Exporting a query to Excel using a Ribbon command.

3. On the Export dialog, edit the worksheet name as desired, and browse for an alternate
   location if you don’t want to store the worksheet in the default Documents folder (in
   Figure 12.9, I edited the worksheet name and left the folder at the default setting).

FIGURE 12.9

Editing the worksheet save name in the Export dialog.

Part II Writing VBA Code to Exchange Data between Office Components