Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
Option Explicit 'outlook objects Public oNameSpace As Outlook.NameSpace Public oInboxItem As Variant Public oFolder As Outlook.MAPIFolder Public oMsg As Object 'excel objects Public objexcel As Excel.Application Public objWB As Excel.Workbook Public objFSO As Scripting.FileSystemObject Public excel_filename As String Sub Extract_Reports() 'extracts reports for HomeExpert Set objFSO = CreateObject("Scripting.FileSystemObject") 'opens the excel workbook Call open_workbook Call extract_outlook_info Call close_workbook End Sub Public Sub open_workbook() 'opens the Excel workbook Dim excel_path As String excel_path = "C:\01 simplyspreadsheets\63 home expert\" excel_filename = "master file.xlsx" MsgBox excel_path & " " & excel_filename Set objexcel = CreateObject("excel.application") Set objWB = objexcel.Workbooks.Open(excel_path & excel_filename, ReadOnly:=False) objexcel.Visible = True objWB.Activate End Sub
|Outlook 2010 Calendar||5||63|
|Exchange 2010/Outlook 2016 Calendar permissions greyed out||5||37|
|Export address book entries within Outlook 2016 PST file into Excel spreadsheet||2||34|
|vba excel2010 and 2013||2||37|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!