Tools - References

M

Michelle

I want to send an email using Excel VBA, and I need to ensure that the
Outlook reference is ticked in Tools - References.

1. Can I do that in code?

2. Can I find out which version of Excel I'm in, to ensure that the code
finds the right reference (i.e. Outlook10/Outlook11/Outlook12)

Thanks

Michelle
 
J

Jim Thomlinson

A more effective solution is to use late binding. What you are describing is
called early binding where you create your references at design time via
Tools -> References. The problem you run ninto is that the end user may not
have those references and the code will crash. In late binding you create the
references at run time.

so instead of
dim appOutlook as Outlook.Application
use
dim appOutlook as Object
set appOutlook = CreateObject("Outlook.Appliation")

Note that when you use late binding you will not have intellisence drop
downs on any of your outlook objects and additionally you will need to
replace the Outlook constants such as olMailItem with their actual numeric
values.
 
G

Gary''s Student

To find the version of Excel:

Sub durla()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
XLVersion = xlApp.Version
MsgBox (XLVersion)
End Sub
 
H

Harald Staff

Hi Michelle

You are better off using Late binding, as shown on Dick Kusleika's page
http://www.dicks-clicks.com/excel/olBinding.htm
because you don't need a reference, it's version independent,and it bypasses
Outlooks first security warning "a program is trying to create a mail". How
nice is that ? :)
The second security warning is still a problem though, if you want to Send
the email. Display is ok though. See Ron's page for background and tools for
emailing from Excel, he's the expert on this:
http://www.rondebruin.nl/tips.htm

Best wishes Harald
 
M

Michelle

Thanks Jim, what is the numeric equivalent of olMailItem?

not knowing this is what led me to switch to using 'early binding' in the
first place.

Thanks

M
 
J

Jim Thomlinson

When I code using late binding, I actually write most of the code with the
reference in place. To get the value of any constants you can just write a
line like

msgbox olMailItem
or
debug.print olMailItem

When all of the code is written remove the reference...
 
J

Jim Thomlinson

Here is a full list of Outlook 2002 contants. Copy this into a blank module...

Public Const olReply as Long = 0
Public Const olReplyAll as Long = 1
Public Const olForward as Long = 2
Public Const olReplyFolder as Long = 3
Public Const olRespond as Long = 4
Public Const olOmitOriginalText as Long = 0
Public Const olEmbedOriginalItem as Long = 1
Public Const olIncludeOriginalText as Long = 2
Public Const olIndentOriginalText as Long = 3
Public Const olLinkOriginalItem as Long = 4
Public Const olUserPreference as Long = 5
Public Const olReplyTickOriginalText as Long = 1000
Public Const olOpen as Long = 0
Public Const olSend as Long = 1
Public Const olPrompt as Long = 2
Public Const olDontShow as Long = 0
Public Const olMenu as Long = 1
Public Const olMenuAndToolbar as Long = 2
Public Const olByValue as Long = 1
Public Const olByReference as Long = 4
Public Const olEmbeddeditem as Long = 5
Public Const olOLE as Long = 6
Public Const olFree as Long = 0
Public Const olTentative as Long = 1
Public Const olBusy as Long = 2
Public Const olOutOfOffice as Long = 3
Public Const olSunday as Long = 1
Public Const olMonday as Long = 2
Public Const olTuesday as Long = 4
Public Const olWednesday as Long = 8
Public Const olThursday as Long = 16
Public Const olFriday as Long = 32
Public Const olSaturday as Long = 64
Public Const olFolderDeletedItems as Long = 3
Public Const olFolderOutbox as Long = 4
Public Const olFolderSentMail as Long = 5
Public Const olFolderInbox as Long = 6
Public Const olFolderCalendar as Long = 9
Public Const olFolderContacts as Long = 10
Public Const olFolderJournal as Long = 11
Public Const olFolderNotes as Long = 12
Public Const olFolderTasks as Long = 13
Public Const olFolderDrafts as Long = 16
Public Const olPublicFoldersAllPublicFolders as Long = 18
Public Const olUser as Long = 0
Public Const olDistList as Long = 1
Public Const olForum as Long = 2
Public Const olAgent as Long = 3
Public Const olOrganization as Long = 4
Public Const olPrivateDistList as Long = 5
Public Const olRemoteUser as Long = 6
Public Const olEditorText as Long = 1
Public Const olEditorHTML as Long = 2
Public Const olEditorRTF as Long = 3
Public Const olEditorWord as Long = 4
Public Const olNoFlag as Long = 0
Public Const olFlagComplete as Long = 1
Public Const olFlagMarked as Long = 2
Public Const olFolderDisplayNormal as Long = 0
Public Const olFolderDisplayFolderOnly as Long = 1
Public Const olFolderDisplayNoNavigation as Long = 2
Public Const olDefaultRegistry as Long = 0
Public Const olPersonalRegistry as Long = 2
Public Const olFolderRegistry as Long = 3
Public Const olOrganizationRegistry as Long = 4
Public Const olUnspecified as Long = 0
Public Const olFemale as Long = 1
Public Const olMale as Long = 2
Public Const olImportanceLow as Long = 0
Public Const olImportanceNormal as Long = 1
Public Const olImportanceHigh as Long = 2
Public Const olSave as Long = 0
Public Const olDiscard as Long = 1
Public Const olPromptForSave as Long = 2
Public Const olMailItem as Long = 0
Public Const olAppointmentItem as Long = 1
Public Const olContactItem as Long = 2
Public Const olTaskItem as Long = 3
Public Const olJournalItem as Long = 4
Public Const olNoteItem as Long = 5
Public Const olPostItem as Long = 6
Public Const olDistributionListItem as Long = 7
Public Const olAssociatedContact as Long = 1
Public Const olNone as Long = 0
Public Const olHome as Long = 1
Public Const olBusiness as Long = 2
Public Const olOther as Long = 3
Public Const olOriginator as Long = 0
Public Const olTo as Long = 1
Public Const olCC as Long = 2
Public Const olBCC as Long = 3
Public Const olOrganizer as Long = 0
Public Const olRequired as Long = 1
Public Const olOptional as Long = 2
Public Const olResource as Long = 3
Public Const olMeetingTentative as Long = 2
Public Const olMeetingAccepted as Long = 3
Public Const olMeetingDeclined as Long = 4
Public Const olNonMeeting as Long = 0
Public Const olMeeting as Long = 1
Public Const olMeetingReceived as Long = 3
Public Const olMeetingCanceled as Long = 5
Public Const olNetMeeting as Long = 0
Public Const olNetShow as Long = 1
Public Const olExchangeConferencing as Long = 2
Public Const olBlue as Long = 0
Public Const olGreen as Long = 1
Public Const olPink as Long = 2
Public Const olYellow as Long = 3
Public Const olWhite as Long = 4
Public Const olApplication as Long = 0
Public Const olNamespace as Long = 1
Public Const olFolder as Long = 2
Public Const olRecipient as Long = 4
Public Const olAttachment as Long = 5
Public Const olAddressList as Long = 7
Public Const olAddressEntry as Long = 8
Public Const olFolders as Long = 15
Public Const olItems as Long = 16
Public Const olRecipients as Long = 17
Public Const olAttachments as Long = 18
Public Const olAddressLists as Long = 20
Public Const olAddressEntries as Long = 21
Public Const olAppointment as Long = 26
Public Const olMeetingRequest as Long = 53
Public Const olMeetingCancellation as Long = 54
Public Const olMeetingResponseNegative as Long = 55
Public Const olMeetingResponsePositive as Long = 56
Public Const olMeetingResponseTentative as Long = 57
Public Const olRecurrencePattern as Long = 28
Public Const olExceptions as Long = 29
Public Const olException as Long = 30
Public Const olAction as Long = 32
Public Const olActions as Long = 33
Public Const olExplorer as Long = 34
Public Const olInspector as Long = 35
Public Const olPages as Long = 36
Public Const olFormDescription as Long = 37
Public Const olUserProperties as Long = 38
Public Const olUserProperty as Long = 39
Public Const olContact as Long = 40
Public Const olDocument as Long = 41
Public Const olJournal as Long = 42
Public Const olMail as Long = 43
Public Const olNote as Long = 44
Public Const olPost as Long = 45
Public Const olReport as Long = 46
Public Const olRemote as Long = 47
Public Const olTask as Long = 48
Public Const olTaskRequest as Long = 49
Public Const olTaskRequestUpdate as Long = 50
Public Const olTaskRequestAccept as Long = 51
Public Const olTaskRequestDecline as Long = 52
Public Const olExplorers as Long = 60
Public Const olInspectors as Long = 61
Public Const olPanes as Long = 62
Public Const olOutlookBarPane as Long = 63
Public Const olOutlookBarStorage as Long = 64
Public Const olOutlookBarGroups as Long = 65
Public Const olOutlookBarGroup as Long = 66
Public Const olOutlookBarShortcuts as Long = 67
Public Const olOutlookBarShortcut as Long = 68
Public Const olDistributionList as Long = 69
Public Const olPropertyPageSite as Long = 70
Public Const olPropertyPages as Long = 71
Public Const olSyncObject as Long = 72
Public Const olSyncObjects as Long = 73
Public Const olSelection as Long = 74
Public Const olLink as Long = 75
Public Const olLinks as Long = 76
Public Const olSearch as Long = 77
Public Const olResults as Long = 78
Public Const olViews as Long = 79
Public Const olView as Long = 80
Public Const olItemProperties as Long = 98
Public Const olItemProperty as Long = 99
Public Const olReminders as Long = 100
Public Const olReminder as Long = 101
Public Const olLargeIcon as Long = 0
Public Const olSmallIcon as Long = 1
Public Const olOutlookBar as Long = 1
Public Const olFolderList as Long = 2
Public Const olPreview as Long = 3
Public Const olApptNotRecurring as Long = 0
Public Const olApptMaster as Long = 1
Public Const olApptOccurrence as Long = 2
Public Const olApptException as Long = 3
Public Const olRecursDaily as Long = 0
Public Const olRecursWeekly as Long = 1
Public Const olRecursMonthly as Long = 2
Public Const olRecursMonthNth as Long = 3
Public Const olRecursYearly as Long = 5
Public Const olRecursYearNth as Long = 6
Public Const olRemoteStatusNone as Long = 0
Public Const olUnMarked as Long = 1
Public Const olMarkedForDownload as Long = 2
Public Const olMarkedForCopy as Long = 3
Public Const olMarkedForDelete as Long = 4
Public Const olResponseNone as Long = 0
Public Const olResponseOrganized as Long = 1
Public Const olResponseTentative as Long = 2
Public Const olResponseAccepted as Long = 3
Public Const olResponseDeclined as Long = 4
Public Const olResponseNotResponded as Long = 5
Public Const olTXT as Long = 0
Public Const olRTF as Long = 1
Public Const olTemplate as Long = 2
Public Const olMSG as Long = 3
Public Const olDoc as Long = 4
Public Const olHTML as Long = 5
Public Const olVCard as Long = 6
Public Const olVCal as Long = 7
Public Const olICal as Long = 8
Public Const olNormal as Long = 0
Public Const olPersonal as Long = 1
Public Const olPrivate as Long = 2
Public Const olConfidential as Long = 3
Public Const olSortNone as Long = 0
Public Const olAscending as Long = 1
Public Const olDescending as Long = 2
Public Const olTaskNotDelegated as Long = 0
Public Const olTaskDelegationUnknown as Long = 1
Public Const olTaskDelegationAccepted as Long = 2
Public Const olTaskDelegationDeclined as Long = 3
Public Const olNewTask as Long = 0
Public Const olDelegatedTask as Long = 1
Public Const olOwnTask as Long = 2
Public Const olUpdate as Long = 2
Public Const olFinalStatus as Long = 3
Public Const olTaskSimple as Long = 0
Public Const olTaskAssign as Long = 1
Public Const olTaskAccept as Long = 2
Public Const olTaskDecline as Long = 3
Public Const olTaskNotStarted as Long = 0
Public Const olTaskInProgress as Long = 1
Public Const olTaskComplete as Long = 2
Public Const olTaskWaiting as Long = 3
Public Const olTaskDeferred as Long = 4
Public Const olTrackingNone as Long = 0
Public Const olTrackingDelivered as Long = 1
Public Const olTrackingNotDelivered as Long = 2
Public Const olTrackingNotRead as Long = 3
Public Const olTrackingRecallFailure as Long = 4
Public Const olTrackingRecallSuccess as Long = 5
Public Const olTrackingRead as Long = 6
Public Const olTrackingReplied as Long = 7
Public Const olOutlookInternal as Long = 0
Public Const olText as Long = 1
Public Const olNumber as Long = 3
Public Const olDateTime as Long = 5
Public Const olYesNo as Long = 6
Public Const olDuration as Long = 7
Public Const olKeywords as Long = 11
Public Const olPercent as Long = 12
Public Const olCurrency as Long = 14
Public Const olFormula as Long = 18
Public Const olCombination as Long = 19
Public Const olMaximized as Long = 0
Public Const olMinimized as Long = 1
Public Const olNormalWindow as Long = 2
Public Const olSyncStopped as Long = 0
Public Const olSyncStarted as Long = 1
Public Const olFormatUnspecified as Long = 0
Public Const olFormatPlain as Long = 1
Public Const olFormatHTML as Long = 2
Public Const olFormatRichText as Long = 3
Public Const olHeaderOnly as Long = 0
Public Const olFullItem as Long = 1
Public Const olExcelWorkSheetItem as Long = 8
Public Const olWordDocumentItem as Long = 9
Public Const olPowerPointShowItem as Long = 10
Public Const olViewSaveOptionThisFolderEveryone as Long = 0
Public Const olViewSaveOptionThisFolderOnlyMe as Long = 1
Public Const olViewSaveOptionAllFoldersOfType as Long = 2
Public Const olTableView as Long = 0
Public Const olCardView as Long = 1
Public Const olCalendarView as Long = 2
Public Const olIconView as Long = 3
Public Const olTimelineView as Long = 4
 
M

Michelle

Thanks Jim.

M


Jim Thomlinson said:
Here is a full list of Outlook 2002 contants. Copy this into a blank
module...

Public Const olReply as Long = 0
Public Const olReplyAll as Long = 1
Public Const olForward as Long = 2
Public Const olReplyFolder as Long = 3
Public Const olRespond as Long = 4
Public Const olOmitOriginalText as Long = 0
Public Const olEmbedOriginalItem as Long = 1
Public Const olIncludeOriginalText as Long = 2
Public Const olIndentOriginalText as Long = 3
Public Const olLinkOriginalItem as Long = 4
Public Const olUserPreference as Long = 5
Public Const olReplyTickOriginalText as Long = 1000
Public Const olOpen as Long = 0
Public Const olSend as Long = 1
Public Const olPrompt as Long = 2
Public Const olDontShow as Long = 0
Public Const olMenu as Long = 1
Public Const olMenuAndToolbar as Long = 2
Public Const olByValue as Long = 1
Public Const olByReference as Long = 4
Public Const olEmbeddeditem as Long = 5
Public Const olOLE as Long = 6
Public Const olFree as Long = 0
Public Const olTentative as Long = 1
Public Const olBusy as Long = 2
Public Const olOutOfOffice as Long = 3
Public Const olSunday as Long = 1
Public Const olMonday as Long = 2
Public Const olTuesday as Long = 4
Public Const olWednesday as Long = 8
Public Const olThursday as Long = 16
Public Const olFriday as Long = 32
Public Const olSaturday as Long = 64
Public Const olFolderDeletedItems as Long = 3
Public Const olFolderOutbox as Long = 4
Public Const olFolderSentMail as Long = 5
Public Const olFolderInbox as Long = 6
Public Const olFolderCalendar as Long = 9
Public Const olFolderContacts as Long = 10
Public Const olFolderJournal as Long = 11
Public Const olFolderNotes as Long = 12
Public Const olFolderTasks as Long = 13
Public Const olFolderDrafts as Long = 16
Public Const olPublicFoldersAllPublicFolders as Long = 18
Public Const olUser as Long = 0
Public Const olDistList as Long = 1
Public Const olForum as Long = 2
Public Const olAgent as Long = 3
Public Const olOrganization as Long = 4
Public Const olPrivateDistList as Long = 5
Public Const olRemoteUser as Long = 6
Public Const olEditorText as Long = 1
Public Const olEditorHTML as Long = 2
Public Const olEditorRTF as Long = 3
Public Const olEditorWord as Long = 4
Public Const olNoFlag as Long = 0
Public Const olFlagComplete as Long = 1
Public Const olFlagMarked as Long = 2
Public Const olFolderDisplayNormal as Long = 0
Public Const olFolderDisplayFolderOnly as Long = 1
Public Const olFolderDisplayNoNavigation as Long = 2
Public Const olDefaultRegistry as Long = 0
Public Const olPersonalRegistry as Long = 2
Public Const olFolderRegistry as Long = 3
Public Const olOrganizationRegistry as Long = 4
Public Const olUnspecified as Long = 0
Public Const olFemale as Long = 1
Public Const olMale as Long = 2
Public Const olImportanceLow as Long = 0
Public Const olImportanceNormal as Long = 1
Public Const olImportanceHigh as Long = 2
Public Const olSave as Long = 0
Public Const olDiscard as Long = 1
Public Const olPromptForSave as Long = 2
Public Const olMailItem as Long = 0
Public Const olAppointmentItem as Long = 1
Public Const olContactItem as Long = 2
Public Const olTaskItem as Long = 3
Public Const olJournalItem as Long = 4
Public Const olNoteItem as Long = 5
Public Const olPostItem as Long = 6
Public Const olDistributionListItem as Long = 7
Public Const olAssociatedContact as Long = 1
Public Const olNone as Long = 0
Public Const olHome as Long = 1
Public Const olBusiness as Long = 2
Public Const olOther as Long = 3
Public Const olOriginator as Long = 0
Public Const olTo as Long = 1
Public Const olCC as Long = 2
Public Const olBCC as Long = 3
Public Const olOrganizer as Long = 0
Public Const olRequired as Long = 1
Public Const olOptional as Long = 2
Public Const olResource as Long = 3
Public Const olMeetingTentative as Long = 2
Public Const olMeetingAccepted as Long = 3
Public Const olMeetingDeclined as Long = 4
Public Const olNonMeeting as Long = 0
Public Const olMeeting as Long = 1
Public Const olMeetingReceived as Long = 3
Public Const olMeetingCanceled as Long = 5
Public Const olNetMeeting as Long = 0
Public Const olNetShow as Long = 1
Public Const olExchangeConferencing as Long = 2
Public Const olBlue as Long = 0
Public Const olGreen as Long = 1
Public Const olPink as Long = 2
Public Const olYellow as Long = 3
Public Const olWhite as Long = 4
Public Const olApplication as Long = 0
Public Const olNamespace as Long = 1
Public Const olFolder as Long = 2
Public Const olRecipient as Long = 4
Public Const olAttachment as Long = 5
Public Const olAddressList as Long = 7
Public Const olAddressEntry as Long = 8
Public Const olFolders as Long = 15
Public Const olItems as Long = 16
Public Const olRecipients as Long = 17
Public Const olAttachments as Long = 18
Public Const olAddressLists as Long = 20
Public Const olAddressEntries as Long = 21
Public Const olAppointment as Long = 26
Public Const olMeetingRequest as Long = 53
Public Const olMeetingCancellation as Long = 54
Public Const olMeetingResponseNegative as Long = 55
Public Const olMeetingResponsePositive as Long = 56
Public Const olMeetingResponseTentative as Long = 57
Public Const olRecurrencePattern as Long = 28
Public Const olExceptions as Long = 29
Public Const olException as Long = 30
Public Const olAction as Long = 32
Public Const olActions as Long = 33
Public Const olExplorer as Long = 34
Public Const olInspector as Long = 35
Public Const olPages as Long = 36
Public Const olFormDescription as Long = 37
Public Const olUserProperties as Long = 38
Public Const olUserProperty as Long = 39
Public Const olContact as Long = 40
Public Const olDocument as Long = 41
Public Const olJournal as Long = 42
Public Const olMail as Long = 43
Public Const olNote as Long = 44
Public Const olPost as Long = 45
Public Const olReport as Long = 46
Public Const olRemote as Long = 47
Public Const olTask as Long = 48
Public Const olTaskRequest as Long = 49
Public Const olTaskRequestUpdate as Long = 50
Public Const olTaskRequestAccept as Long = 51
Public Const olTaskRequestDecline as Long = 52
Public Const olExplorers as Long = 60
Public Const olInspectors as Long = 61
Public Const olPanes as Long = 62
Public Const olOutlookBarPane as Long = 63
Public Const olOutlookBarStorage as Long = 64
Public Const olOutlookBarGroups as Long = 65
Public Const olOutlookBarGroup as Long = 66
Public Const olOutlookBarShortcuts as Long = 67
Public Const olOutlookBarShortcut as Long = 68
Public Const olDistributionList as Long = 69
Public Const olPropertyPageSite as Long = 70
Public Const olPropertyPages as Long = 71
Public Const olSyncObject as Long = 72
Public Const olSyncObjects as Long = 73
Public Const olSelection as Long = 74
Public Const olLink as Long = 75
Public Const olLinks as Long = 76
Public Const olSearch as Long = 77
Public Const olResults as Long = 78
Public Const olViews as Long = 79
Public Const olView as Long = 80
Public Const olItemProperties as Long = 98
Public Const olItemProperty as Long = 99
Public Const olReminders as Long = 100
Public Const olReminder as Long = 101
Public Const olLargeIcon as Long = 0
Public Const olSmallIcon as Long = 1
Public Const olOutlookBar as Long = 1
Public Const olFolderList as Long = 2
Public Const olPreview as Long = 3
Public Const olApptNotRecurring as Long = 0
Public Const olApptMaster as Long = 1
Public Const olApptOccurrence as Long = 2
Public Const olApptException as Long = 3
Public Const olRecursDaily as Long = 0
Public Const olRecursWeekly as Long = 1
Public Const olRecursMonthly as Long = 2
Public Const olRecursMonthNth as Long = 3
Public Const olRecursYearly as Long = 5
Public Const olRecursYearNth as Long = 6
Public Const olRemoteStatusNone as Long = 0
Public Const olUnMarked as Long = 1
Public Const olMarkedForDownload as Long = 2
Public Const olMarkedForCopy as Long = 3
Public Const olMarkedForDelete as Long = 4
Public Const olResponseNone as Long = 0
Public Const olResponseOrganized as Long = 1
Public Const olResponseTentative as Long = 2
Public Const olResponseAccepted as Long = 3
Public Const olResponseDeclined as Long = 4
Public Const olResponseNotResponded as Long = 5
Public Const olTXT as Long = 0
Public Const olRTF as Long = 1
Public Const olTemplate as Long = 2
Public Const olMSG as Long = 3
Public Const olDoc as Long = 4
Public Const olHTML as Long = 5
Public Const olVCard as Long = 6
Public Const olVCal as Long = 7
Public Const olICal as Long = 8
Public Const olNormal as Long = 0
Public Const olPersonal as Long = 1
Public Const olPrivate as Long = 2
Public Const olConfidential as Long = 3
Public Const olSortNone as Long = 0
Public Const olAscending as Long = 1
Public Const olDescending as Long = 2
Public Const olTaskNotDelegated as Long = 0
Public Const olTaskDelegationUnknown as Long = 1
Public Const olTaskDelegationAccepted as Long = 2
Public Const olTaskDelegationDeclined as Long = 3
Public Const olNewTask as Long = 0
Public Const olDelegatedTask as Long = 1
Public Const olOwnTask as Long = 2
Public Const olUpdate as Long = 2
Public Const olFinalStatus as Long = 3
Public Const olTaskSimple as Long = 0
Public Const olTaskAssign as Long = 1
Public Const olTaskAccept as Long = 2
Public Const olTaskDecline as Long = 3
Public Const olTaskNotStarted as Long = 0
Public Const olTaskInProgress as Long = 1
Public Const olTaskComplete as Long = 2
Public Const olTaskWaiting as Long = 3
Public Const olTaskDeferred as Long = 4
Public Const olTrackingNone as Long = 0
Public Const olTrackingDelivered as Long = 1
Public Const olTrackingNotDelivered as Long = 2
Public Const olTrackingNotRead as Long = 3
Public Const olTrackingRecallFailure as Long = 4
Public Const olTrackingRecallSuccess as Long = 5
Public Const olTrackingRead as Long = 6
Public Const olTrackingReplied as Long = 7
Public Const olOutlookInternal as Long = 0
Public Const olText as Long = 1
Public Const olNumber as Long = 3
Public Const olDateTime as Long = 5
Public Const olYesNo as Long = 6
Public Const olDuration as Long = 7
Public Const olKeywords as Long = 11
Public Const olPercent as Long = 12
Public Const olCurrency as Long = 14
Public Const olFormula as Long = 18
Public Const olCombination as Long = 19
Public Const olMaximized as Long = 0
Public Const olMinimized as Long = 1
Public Const olNormalWindow as Long = 2
Public Const olSyncStopped as Long = 0
Public Const olSyncStarted as Long = 1
Public Const olFormatUnspecified as Long = 0
Public Const olFormatPlain as Long = 1
Public Const olFormatHTML as Long = 2
Public Const olFormatRichText as Long = 3
Public Const olHeaderOnly as Long = 0
Public Const olFullItem as Long = 1
Public Const olExcelWorkSheetItem as Long = 8
Public Const olWordDocumentItem as Long = 9
Public Const olPowerPointShowItem as Long = 10
Public Const olViewSaveOptionThisFolderEveryone as Long = 0
Public Const olViewSaveOptionThisFolderOnlyMe as Long = 1
Public Const olViewSaveOptionAllFoldersOfType as Long = 2
Public Const olTableView as Long = 0
Public Const olCardView as Long = 1
Public Const olCalendarView as Long = 2
Public Const olIconView as Long = 3
Public Const olTimelineView as Long = 4
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Reference 1
Add-ins Referencing 2
Word VBA to update cross-referencing 0
References to Other Workbooks Don't Stick 6
Early variable type issue 9
macro to select reference in tools-->references 1
Missing References 1
Excel VBA 2

Top