Export Outlook Calendar

Status
Not open for further replies.

donwb

Member
Outlook version
Email Account
POP3
Excel & Outlook 2003 running under Windows 7 Pro. 64 bit



I export the Outlook Calendar to an Excel file (MyData.xls) for subsequent use in another Excel application (call it Application X)



The resulting format of the exported data in MyData.xls requires manipulation (remove leading apostrophes and re-format the date) to make it suitable for use in Application X. This is done within MyData.xls with a macro called “RemoveApostrophes”



I assume that when the Calendar data is exported, Outlook opens MyData.xls to receive the data, then closes it.



How can I use the MyData.xls closing event to trigger it’s “RemoveApostrophes” macro?



Alternatively, could a suitable macro, triggered by the Outlook closing event, achieve this.

I have tried many ways of doing this without success. At some point the command <<Workbooks("MyData").Close save changes = true>
is needed, but hangs with the message "script out of range"
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'm not sure you can trap Outlook closing the workbook, there are a limited number of events you can trap and offhand, i don't think any of outlook's will work.

Can you use an application start macro in excel, maybe with a timer so that outlook have time to finish before the macro kicks in?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
M outlook shared calendar data export to excel sheet Using Outlook 1
Owl Export Outlook PDF Attachment as JPG? Outlook VBA and Custom Forms 3
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 1
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
Diane Poremsky Export (Save) Outlook Contact photos Using Outlook 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
H How to export *all* fields from Outlook Using Outlook 2
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
T Outlook 2007 Export tasks to Excel Using Outlook 2
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
F Export Outlook contacts by One Category Using Outlook 1
O Export (save) Outlook Contact photos Using Outlook 2
C Outlook 200? - Script Export Rules Using Outlook 1
K outlook 2007 Export/Import Distribution lists Using Outlook 1
P Cannot export contacts with Outlook 2003 Using Outlook 10
C outlook export to excel in real time Using Outlook 3
M Why msg files are differ after export from Outlook to filesystem? Outlook VBA and Custom Forms 4
R Export email from Outlook into Access... Outlook VBA and Custom Forms 3
K Disabling import/export button to restrict PST creation Using Outlook 3
K Export Folder to PST Outlook VBA and Custom Forms 2
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 0
M Export-Import .pst file problems Using Outlook 2
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
N Export details to a excel spreadsheet using macros Using Outlook 0
avant-guvnor Export Calendar, Birthdays and Holidays Outlook VBA and Custom Forms 0
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
A How to export one email data to excel Using Outlook 1
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
E Exchanger service export detection Exchange Server Administration 1
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
K Export Organizational Forms Library Exchange Server Administration 1
E RSS export as OPML problem Using Outlook 4
A export free / busy from exchange Exchange Server Administration 0
C Export to excel missing items, but a larger total? BCM (Business Contact Manager) 6
J Opening/Archiving/Import/Export PST files Using Outlook 4
H Select one of Contact-Mailadesses to Export > Excel or Winword Outlook VBA and Custom Forms 2
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4

Similar threads

Top