W


Web browsers, Help system, 792-794
Web pages, developers and, 14
Weekday function, 987
WeekdayName function, 987
welcome messages, 639
what-if models, 106
While Wend statement, 981
Width # statement, 981
WindowActivate event, 638, 656
WindowDeactivate event, 638, 656
WindowResize event, 638, 656
windows
activating, 977
docking, 157
hiding, 16
Windows API
default printer information, 379-380
directory, 311-312
directory selection, 404-406
disk drive information, 378
DLL (Dynamic Link Library) files, 311
file associations, 377-378
functions, 311-314
GetExecutable function, 377-378
MIDI files, 382-383
prompting for directories, 403
Registry, 384
Registry, reading from, 384-385
Registry, writing to, 385-386
ShellExecute function, 672-674
Shift key, 313
sound, playing from function, 383-384
video display information, 380-381
WAV files, 382
Windows, Macintosh and, 820-821
WinHelp, 794
With statement, 981
With-End With construct, 217-218
wizards
buttons , adding, 501-502
buttons, programming, 502-503
Finish button, 505-506
MultiPage control, 500-501
programming dependencies, 503-505
Word, controlling from Excel, 681-684
workbook events
Activate, 637, 640
AddinInstall, 637
AddinUninstall, 637
AfterXMLExport, 637
AfterXMLImport, 637
BeforeClose, 637, 643-645
BeforePrint, 637, 642-643
BeforeSave, 637, 640-641
BeforeXMLExport, 638
BeforeXMLImport, 638
Deactivate, 638, 641-642
description, 630
NewSheet, 638, 640
Open , 638, 639
PivotTableCloseConnection, 638
PivotTableOpenConnection, 638
RowsetComplete, 638
SheetActivate, 638, 640
SheetBeforeDoubleClick, 638
SheetBeforeRightClick, 638
SheetCalculate, 638
SheetChange, 638
SheetDeactivate, 638
SheetFollowHyperlink, 638
SheetPivotTableUpdate, 638
SheetSelectionChange, 638
Sync, 638
WindowActivate, 638
WindowDeactivate, 638
WindowResize, 638
workbook objects, 16
WorkbookActivate event, 656
Workbook_Activate procedure, 640
WorkbookAddInstall event, 656
WorkbookAddUninstall event, 657
WorkbookAfterXMLExport event, 657
WorkbookAfterXMLImport event, 657
WorkbookBeforeClose event, 657
Workbook_BeforeClose procedure, 644
WorkbookBeforePrint event, 657
WorkbookBeforeSave event, 657
Workbook_BeforeSave procedure, 641
WorkbookBeforeXMLExport event, 657
WorkbookBeforeXMLImport event, 657
WorkbookDeactivate event, 657
Workbook_Deactivate procedure, 641
WorkbookIsOpen function, 358
WorkbookNewSheet event, 657
Workbook_NewSheet procedure, 640
WorkbookOpen event, 657
Workbook_Open procedure, 639, 644
WorkbookPivotTableCloseConnection event, 657
WorkbookPivotTableOpenConnection event, 657
WorkbookRowSetComplete event, 657
workbooks
accessing add-ins as, 719
active, 16
add-ins, setup for, 705
closing, 344-345
creating add-ins from, 703-704
determining when opened, 658-659
document themes, 18
fonts, 934
introduction, 16
macro viruses, 939
opening, 639
procedures, listing all, 866
protecting, 123
read-only, 124
RibbonX code, 737-739
saving, 344
templates, creating, 84
Workbook_SheetActivate procedure, 640
WorkbookSync event, 657
worksheet events
Activate, 645
BeforeDoubleClick, 645, 652-653
BeforeRightClick, 645, 653-654
Calculate, 645
Change, 645-646
Deactivate, 645
description, 630
FollowHyperlink, 645
PivotTableUpdate, 645
SelectionChange, 645, 651-652
worksheet functions, add-ins, 105
Worksheet object
Cells property, 182-183
Range property, 181
worksheet sort , arrays, 352
Worksheet_BeforeDoubleClick procedure, 653
Worksheet_BeforeRightClick procedure, 653
Worksheet_Change procedure, 646
WorksheetFunction object, functions, 215
worksheets
activating, 639
activating, ListBoxes and, 476-479
active, 16
ActiveX controls, 118-120
built-in functions, 948
controls, using, 419-420
databases, 39-40
functions, 278
Help system, 784, 787-788
hiding, 123
introduction, 16
Loan Amortization Wizard and, 809-810
name , changing, 16
objects, locking, 123
Print Preview, 348-349
printed pages, number of, 348-349
scrolling, UserForms, 458-460
size , 17
synchronization, 346-347
Text Tools workbook, 537
XLAM files, 711
XLSM files, 711
zooming, UserForms, 458-460
Worksheet_SelectionChange procedure, 651
workspace files, 80
wrapper functions, 287
Write # statement, 844, 981
write position, text files, 985
WriteReadRange procedure, 336-337
writing to
ranges, 336-337, 337-339
text files, 843-844
Wrong number of arguments or invalid property assignment error, 992



Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net