W

Wallentin, Dennis, 301-302, 325

warnings. See alerts watches, 48-50 WCL_FTP, 347 Web. See also Web sites

FTP (File Transfer

Protocol), 347 publishing data to, 341-342 content management systems, 344-347 custom Web pages, 343 Save as Web Page command, 341

scheduled macros canceling, 338-339 CaptureData function, 337

DebtClock case study,

340-341 OnTime function, 337 Ready mode, 337-338 running every two minutes, 339-340 running x minutes in the future, 339 ScheduleTheDay function, 337 windows of time for updates, 338 streaming data, 336-337 Web queries, 331

creating manually, 332 creating with VBA,

334-336 refreshing, 332 updating, 333

Web queries, 331

creating manually, 332 creating with VBA, 334-336 refreshing, 332 updating, 333

Web sites

Amazon Development Kit,

354-355 Colo's Junkroom, 297 Excel Tips and Tricks, 301 Klann, Daniel, 320 Mehta, Tushar, 505 WCL_FTP, 347 XcelFiles, 308

weeks grouping by, 267-268 week numbers, converting to dates, 94

Weekday() function, 94 Wend statement, 113 While clause, 111-112 While...Wend loops, 113

Window menu commands,

Hide, 503 WindowActivate() event, 146, 158

WindowDeactivate() event,

146, 159 WindowResize() event, 146, 159

Windows API

clickable links, 461 computer names, returning,

455-456 display resolution, 457-458 file paths, 462-465 functions apiGetOpenFileName, 462

apiGetSaveFileName, 462

calling, 454-455 CommDlgExtended-

Error, 462 declaring, 453-454 DeleteMenu, 458-459 DisplaySize, 457-458 FileIsOpen, 456-457 FindWindow, 458-459 GetComputerName,

455-456 GetSystemMenu,

458-459 GetUserName, 454-455 PlayWavSound, 462 SetTimer, 460 ShellExecute, 439, 461

online resources, 466 open files, checking for,

456-457 sounds, playing, 462 timer, running, 460 X button, disabling, 458-459 WinUserName() function, 79-81

WinWord.exe, 363 WiringToExcelCoords() function, 509

With...End With statement, 56

WithEvents statement, 416 WithNames() function, 135 wizards

Pivot Table Wizard,

236-238 Text Import Wizard, 21, 38-39

delimited files, 392-394 files with less than

98,304 rows, 394-397 files with more than

98,304 rows, 397-398 fixed-width files, 388-391

Word automation, 359

bookmarks, 371-373 compile errors, 361 Document objects, 365-366 early binding, 359-361 filtered reports, 373-376 late binding, 362 object model, 364-365 object creation, 363-364 object references, 363-364 Range objects, 368-370 Selection objects, 367

WordEarlyBinding()

function, 361 WordLateBinding() function, 362

Workbook_Activate() event,

143, 159 Workbook_AddInInstall() event, 147, 159

Workbook_AddInUninstall()

event, 147, 159 Workbook_BeforeClose() event, 145-146, 159

Workbook_BeforePrint()

event, 144-145, 160 Workbook_BeforeSave() event, 144

Workbook_Deactivate()

event, 143 Workbook_NewSheet() event, 146, 160

Workbook_Open() event,

143-144, 160 Workbook_SheetActivate() event, 147

Workbook_SheetBefore-

DoubleClickO event, 147 Workbook_SheetBefore-RightClick() event, 147

Workbook_SheetCalculate()

event, 147 Workbook_SheetChange() event, 148

Workbook_Sheet-

Deactivate() event, 148 Workbook_SheetFollow-Hyperlink() event, 148

Workbook_SheetSelection-Change() event, 148

Workbook_Window-Activate() event, 146

Workbook_Window-Deactivate() event, 146

Workbook_WindowResize() event, 146

workbooks checking for open workbooks, 77-78 combining, 300-301 converting to add-ins,

498-500 date/time of last save, retrieving, 81 deleting after specific date,

295 events list of, 143

Workbook_Activate(),

143, 159 Workbook_AddIn-Install(), 147, 159 Workbook_AddIn-

Uninstall(), 147, 159 Workbook_Before-

Close(), 145-146, 159 Workbook_ BeforePrint(), 144-145, 160

Workbook_BeforeSave(), 144

Workbook_Deactivate(), 143

Workbook_NewSheet(),

146, 160 Workbook_Open(),

143-144, 160 Workbook_Sheet-

Activate(), 147 Workbook_SheetBefore

DoubleClick(), 147 Workbook_SheetBefore RightClick(), 147

Workbook_Sheet-Calculate(), 147 Workbook_Sheet-

Change(), 148 Workbook_Sheet-Deactivate(), 148 Workbook_SheetFollow

Hyperlink(), 148 Workbook_Sheet-

SelectionChange(), 148 Workbook_Window-

Activate(), 146 Workbook_Window-

Deactivate(), 146 Workbook_Window-Resize(), 146 file paths, 77 hiding, 503 names, 77

number of workbooks, counting, 79 Personal Macro Workbook, 16

Report workbooks, 250-251 separating worksheets into, 299-300

Worksheet_Activate() event, 149

Worksheet_BeforeDouble-Click() event, 149

Worksheet_BeforeRight-

Click() event, 150 Worksheet_Calculate() event, 150

Worksheet_Change() event,

150-151 Worksheet_Change() function, 292, 319-320

Worksheet_Deactivate() event, 149

Worksheet_Follow-Hyperlink() event, 152

Worksheet_Selection-Change() event, 152 Worksheet_Selection-Change() function, 308, 326

worksheets. See also cells; workbooks blank report worksheets, moving pivot table data to, 251 checking for, 78-79 filtering and copying data to, 301-302 separating into workbooks,

299-300 worksheet events, 149-152 WriteFile() function, 398 WriteHTML() function, 472 WriteMembershipHTML() function, 345-346

0 0

Post a comment