Access.2007.VBA.Bibl..

worksheets, Excel (continued)

formatted, using templates to create, 52–62

formatting in VBA code, 62–69

minimally formatted, creating, 191–195

simple, tabular, creating, 191–195

unformatted, exporting Access data to, 50–52

ways of creating, 62

versus workbooks, 183

worksheets, legacy, importing, 324–328

worksheet-type reports, Access, 11–19

Workspaceobject, 99, 130

WriteTextmethod, 291

WSH (Windows Script Host)

Microsoft Script Editor, 592–606

office scripts, 611–616

overview, 591

setup scripts, 603–611

tools for scripts, 591–599

useful scripts, 603–619

VBScript Help File, 597–599

X

XCopy feature, 629

.xls file format, 61, 183

.xlsx file format, 61, 183

XML files. See alsoHTML files

and Access, 338

code for AddButtons Ribbon, 547–548

code for ExtrasRibbon, 550–551

color-coding for code, 516, 525, 526

creating and editing code, 517–519

creating code, 522–542

exporting, 341–347

importing, 338–341

opening in Excel, 346–347

opening in Internet Explorer, 345–346

XML Notepad 2007, 517, 525

Z

ZipCode DocProperty field, 152–153

W Index

25_047026 bindex.qxp 4/2/07 9:58 PM Page 700