Access.Application
-provides access to the MS Access application
Properties Visible (Read/Write) set to TRUE to make application visible to user
Methods
DBEngine.OpenDatabase(strDBPath) returns object
opens .mdb file at the end of the path and returns database object
DBEngine.WorkSpaces(0).CreateDatabase(strDBPath, dbLangGeneral) returns object
creates an access database and returns database object
DoCmd.OpenReport(strReport, intMode)
opens a report in the access database, Open(2: preview)
NewCurrentDatabase(strDBPath)
creates an access database
OpenCurrentDatabase(strDBPath)
opens .mdb file at the end of the DBpath for the purpose of editing forms
Database Object
-provides access to MS Access Databases
Methods
Execute(strSQL, dbFailOnError)
executes SQL statement
OpenRecordSet(strTable) returns object
opens record and returns record object
RecordSet Object
-provides access to records in an MS Access Database
Collections Fields (Read-Only) associative array of all objects in the record
Methods
AddNew()
adds a new record to the database
Update()
updates a record in the database
Field Object
-provides access to MS Access Database field properties
Properties AllowZeroLength (Read-Only) set to True to allow zero length strings in the field DefaultValue (Read-Only) default value in the field Name (Read-Only) name of the field in the record Required (Read-Only) set to True to require a value in the field Type (Read-Only) type of field Value (Read/Write) value in the field of the record
Excel.Application
-provides access to the excel application
Properties DisplayFormulaBar (Read/Write) is TRUE if formula bar is visible ScreenUpdating (Read/Write) is False if screen updating is off Visible (Read/Write) set to TRUE to make Excel visible to user Workbooks (Read/Write) reference to object
Methods
Calculate()
recalculates all worksheets in all open workbooks
Workbooks Object
-provides access to excel workbooks
Collections Worksheets (Read-Only) collection of all in the workbook (first index is 1, not 0)
Add() returns object
creates a new default workbook and returns workbook object
Close([boolSaveChanges])
closes current workbook, SaveChanges(true: saves changes before closing, false: does not save changes before closing)
Open(strPath) returns object
opens an existing excel workbook and returns workbook object
SaveAs(strPath)
saves workbook as a new excel file
Worksheets Object
-provides access to excel worksheets
Collections Columns(intY) (Read/Write) collection of all in the worksheet Cells(intX, intY) (Read/Write) two-dimensional array of all in the worksheet Range(A1:C1) (Read/Write) range of in the worksheet Rows(intX) (Read/Write) collection of all of the worksheet
Properties Name (Read/Write) name given to the worksheet
Methods
Add() returns object
creates a new default worksheet and returns worksheet object
Calculate()
recalculates all cells in the worksheet
Close()
closes open worksheet
Select()
selects worksheet specified in Worksheets associative array
Range Object
-provides access to individual cells in the worksheet
Properties ColumnWidth (Read/Write) width of the column Font.Bold (Read/Write) is true if cell font is bold Font.ColorIndex (Read/Write) color of specified cell Formula (Read/Write) math formula in the cell HorizontalAlignment (Read/Write) horizontal alignment in the cells (xlLeft, xlRight) Interior.Pattern (Read/Write) pattern of specified cell (xlSolid) Value (Read/Write) value in the specified cell
Methods
AutoFit()
sutomatically lengthens cellwidth if needed
ClearContents()
clears the contents of cells
Select()
selects specified range of cells
Sort(rangeObject, constOrder)
sorts selected range in order, Order(xlAscending, xlDescending)
InternetExplorer.Application
-provides access to the application internet explorer and the DOM
Properties Addressbar (Read/Write) set to FALSE to remove addressbar Busy (Read-Only) is TRUE if IE is busy loading Document (Read-Only) reference to the document object model FullName (Read-Only) path to iexplore.exe FullScreen (Read/Write) set to TRUE to maximize window Height (Read/Write) height of the IE window in pixels Left (Read/Write) left screen margin of the IE window in pixels LocationName (Read/Write) title of the loaded html page LocationURL (Read/Write) location in the addressbar OffLine (Read/Write) set to TRUE to put browser in Offline mode Top (Read/Write) top screen margin of the IE window in pixels MenuBar (Read/Write) set to FALSE to remove menubar from IE window Name (Read-Only) name of Internet Explorer Path (Read-Only) path to but not including iexplore.exe Resizable (Read/Write) set to FALSE to make IE window non-resizable Toolbar (Read/Write) set to FALSE to remove toolbar from IE window Silent (Read/Write) set to TRUE to prevent dialogue boxes StatusBar (Read/Write) set to FALSE to remove statusbar from IE window StatusText (Read/Write) text in the statusbar Visible (Read/Write) set to TRUE to make Internet Explorer visible Width (Read/Write) width of the IE window in pixels
Methods
GoBack()
sends Internet Explorer back one item in the history list
GoForward()
sends Internet Explorer forward one item in the history list
GoHome()
sends Internet Explorer to the home page specified in the Internet Explorer control panel
GoSearch()
sends Internet Explorer to the search page specified in the Internet Explorer control panel
Navigate(strURL)
opens URL in the current IE object window
Quit()
closes the Internet Explorer Application
Refresh()
refreshes the current document in the Internet Explorer application
Stop()
stops Internet Explorer from performing any current actions
Outlook.Application
-provides access to the MS Outlook Application
Methods
CreateItem(intItem) returns Object
creates a new item, Item{(0), (1), (2), (3), olJournalItem(4), olNoteItem(5), olPostItem(6)}
GetNameSpace("MAPI") returns
creates and returns MAPI object (MAPI.Session control)
MailItem Object
-object is returned by Outlook.Application CreateItem(0) method
-provides access to creating and sending emails
Properties Body (Read/Write) text in the body of the message DeleteAfterSubmit (Read/Write) set to TRUE to delete message after it is sent Subject (Read/Write) subject of the message
Methods
Attachments.Add(strFilePath)
adds a file as an attachment to the message
Display()
shows the MailItem as a new message window
Recipients.Add([strEmailAddress]) returns Object
adds emailaddress as a recipient to the message
Send()
sends the message
MailRecipient Object
-object is returned by Mailitem Object Recipients.Add() method
-provides access to recipient properties
Properties Type (Read/Write) type of recipient {olOriginator(0), olTo(1), olCC(2), olBCC(3)}
Appointment Object
-object is returned by Outlook.Application CreateItem(1) method
-provides access to creating appointments
Properties End (Read/Write) date and time the appointment will end Location (Read/Write) location of the appointment Start (Read/Write) date and time for appointment Subject (Read/Write) subject of the appointment ReminderMinutesBeforeStart (Read/Write) minutes between appiontment reminders
Methods
Display()
shows the appointment as a new appointment dialog window
Save()
saves the appointment
ContactItem Object
-object is returned by Outlook.Application CreateItem(2) method
-provides access to creating contacts in the contact list
Properties FirstName (Read/Write) contacts's first name LastName (Read/Write) contact's last name BusinessTelephoneNumber (Read/Write) contact's business phone number Email1Address (Read/Write) contact's email address CompanyName (Read/Write) contact's company name JobTitle (Read/Write) contact's Job title
Methods
Display()
shows the contactitem as a new contact dialog window
Save()
saves the contact into your contact list
TaskItem Object
-object is returned by Outlook.Application CreateItem(3) method
-provides access to creating tasks
-status constants:
olTaskNotStarted(0) olTaskInProgress(1) olTaskComplete(2) olTaskWaiting(3) olTaskDeferred(4)
Properties ActualWork (Read/Write) time in minutes that the task has been worked on Body (Read/Write) text in the description of the task Categories (Read/Write) items in the Categories field Categories (Read/Write) TRUE if task is complete DueDate (Read/Write) date and time the task is due DateCompleted (Read/Write) date and time the task is completed Importance (Read/Write) olImportanceLow(0), olImportanceNormal(1), olImportanceHigh(2) Owner (Read/Write) owner of the task PercentComplete (Read/Write) percentage 0 - 100 that the task is complete Reminder (Read/Write) TRUE if the reminder was set ReminderTime (Read/Write) date and time when the rminder will go off Status (Read/Write) status of the task Subject (Read/Write) subject of the task
Methods
Display()
shows the taskitem as a new task dialog window
Recipients.Add([strEmailAddress]) returns Object
sends the task to the recipient
Save()
saves the task
TaskRecipient Object
-object is returned by TaskItem Object Recipients.Add() method
-provides access to recipient properties
Properties Type (Read/Write) type of recipient {olUpdate(2), olFinalStatus(3)}
MAPI Object (MAPI.Session)
-object is returned by Outlook.Application GetNameSpace("MAPI") method
-also can be created on its own as MAPI.Session control
-provides access to addressbook and outlook profiles
Collections AddressLists (Read-Only) collection containing all objects Inbox (Read-Only) Outlook object
Methods
GetDefaultFolder(itemFolder) returns collection of Objects
gets all the itemobjects ina folder, Folder{olFolderDeletedItems(3), olFolderOutbox(4), olFolderSentMail(5), olFolderInbox(6), olFolderCalendar(9), olFolderContacts(10), olFolderJournal(11), olFolderNotes(12), olFolderTasks(13), olFolderDrafts(16)}
Logon([strProfile], [strPassword], [boolShowDialog])
logs onto MAPI session, ShowDialog(true: displays the MAPI logon dialog)
Logoff()
logs off of MAPI session
AddressBook Object
-object is sub-object of the MAPI object
-provides access to email addresses of outlook user
Collections AddressEntries (Read-Only) collection of all email addresses in the address book
Inbox Object
-object is sub-object of MAPI object
-provides access to the inbox of outlook user
Collections Messages (Read-Only) collection of all messages in the inbox
Word.Application
-provides access to the MS Word application
Collections Documents (Read-Only) collection of all open documents
Properties Options.PrintBackground (Read/Write) set to false so background is not printed Visible (Read/Write) set to TRUE to make word document visble to user
Methods
ActiveDocument.PrintOut()
prints the current open document
Close()
closes the open word document
Documents.Add()
creates a new document as default.doc
Documents.Open(strDocumentPath)
opens word document at the of the path
Quit()
quits the application Microsoft Word
SaveAs(strPath)
saves current document with a new name
Selection.TypeText(strText)
puts text into the body of the word document
[ Comment, Edit or Article Submission ]
