Module: modSnippetExcel
Working within Excel
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modSnippetExcel module
|
|
OpenWorkbooksToArray
|
Procedure
|
Load an array with information about all open workbooks
|
|
SendAsMail
|
Procedure
|
Sends the current workbook to the named recipient via email
|
|
ShowExcelInfo
|
Procedure
|
Basic information about Excel itself. Useful for putting in an About box.
|
|
ShowWorksheetsTree
|
Procedure
|
A list of all worksheets in all open workbooks
|
|
SpellCheckRange
|
Procedure
|
Shows how to use the CheckSpelling method to check for spelling errors in a specified range
|
|
SpellCheckRange2
|
Procedure
|
Shows how to spell check individual values in a specified range
|
|
StartAccess
|
Procedure
|
Shows how to easily start the Microsoft Access application using Excel
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
All Our Microsoft Access Products
(885K)
