P

page fields, 276-279

page setup, 313-315

problems with, 473 parameters events, 142 methods, 32-33, 37

parsing CSV files, 298-299

PassAnArray() function, 386

passing arrays, 386

PasswordBox() function, 322

passwords checking, 477-478 protected password box, 320-322

paste operations, disabling, 316-318, 328-329

percentages percentage growth from previous month, 286-287 reporting in pivot tables, 286-288

permanent date/time, retrieving, 81

Personal Macro Workbook, 16

Perspective property (charts), 198

Picture Catalog userform,

444-446 pie charts, 196, 199-201, 204 pipe character (|), 336 pivot table reports, creating, 250

automatic subtotals, 254 blank report worksheets, moving data to, 251 executive overviews,

271-274 formatting, 253 outline view, 252-253 Product Line Manager sample report, 255-257 region/product reports,

276-279 Report workbooks, 250-251

Pivot Table Wizard, 236-238

pivot tables, 235

averages, 284-285 blank cells, deleting,

245-246 calculated data fields,

260-264 creating with Pivot Table

Wizard, 236-238 creating with VBA, 238-240 limitations, 241 sums of revenues,

240-241 table size, 241-243 default pivot tables,

243-245 Excel 97, 288-289 executive overviews, 271-274

grand totals, suppressing, 250

grouping data, 264-267 grouping by week,

267-268 order lead time, measuring, 269-271 minimums/maximums,

284-285 multiple data fields,

258-260 number format, 247, 249 page fields, 276-283 percentages, 286-288 PivotFields, filtering, 280-283

recordsets, filtering,

274-276 reports automatic subtotals, 254 blank report worksheets, moving data to, 251 executive overviews,

271-274 formatting, 253 outline view, 252-253 Product Line Manager sample report, 255-257 region/product reports,

276-279 Report workbooks, 250-251 ShowDetail feature, 274-276

sort order, 246-247 subtotals, 249, 254 sums, 284-285 Top 10 AutoShow feature,

271-274 versions, 235

PivotExcel97Compatible()

function, 288-289 PivotTable Field dialog box, 246

PlaceGraph() function, 307 playing sounds, 462 PlaySound() function, 462 PlayWavSound API function, 462

plot area, 186-188 PlotArDemo() function, 187 PlotArea object, 186-188 positioning objects, 186-187

previously scheduled macros, canceling, 338-339 Print Area reserved name, 138

Print Titles reserved name,

138 printing page setup, 313-315 Word documents, 366

PrintOut, 366

private API functions, 454

ProduceReportOfTwoProdu cts() function, 281-283 Product Line Manager sample report, 255-257

ProductLineManagerReport

() function, 255-257 ProgIds, 442-443 Programming window, 22-24 progress indicator, 319-320 Project Explorer, 19 Project Explorer command (View menu), 19

projects, locking, 477-478 Properties window (VBE), 20

Property Get procedure, 422-423

Property Let procedure,

422-423 protected password box, 320-322

protecting code, 477-478 protocols, FTP (File Transfer Protocol), 347

public API functions, 454 publishing to Web, 341-342

content management systems, 344-347 custom Web pages, 343 Save as Web Page command, 341

pyramid charts, 197

0 0

Post a comment