Automated export of calender

[Guest]

As the Macro Record button is gone (which I and several with me think is not the best idea presented by MS) I have a problem. We publish our calender and we wish to make the export easier by buliding a button that will do this and enter all the values that are the same each time. The only value we have to change might be the time-span in the calander that should be exported.

So all of you that are VB-oracles give me some hints! And I am looking forward to the re-introduction of the record macro-button as it was back in the good ol' days.

rs

 

[Sue Mosher [MVP]]

Outlook has never had a macro recorder. Neither do most Office programs.
Word and Excel are exceptions.

You would have to write code. The details depend on what you mean by
"publish our calendar."
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

As the Macro Record button is gone (which I and several with me think is

not the best idea presented by MS) I have a problem. We publish our calender
and we wish to make the export easier by buliding a button that will do this
and enter all the values that are the same each time. The only value we have
to change might be the time-span in the calander that should be exported.

So all of you that are VB-oracles give me some hints! And I am looking

forward to the re-introduction of the record macro-button as it was back in
the good ol' days.

 

[Sue Mosher [MVP]]

If you have a macro already written, you can add it to the toolbar with the
View | Toolbars | Customize dialog.

You might find the group calendar applications that include VB sample code
(see http://www.slipstick.com/calendar/scheduleall.htm) useful, as well as
the Word calendar templates at
http://www.slipstick.com/addins/calendar.htm#print . In any case, the
application you're describing is somewhat complex. While the volunteers to
hang out in this newsgroup will be happy to answer specific questions, you
can't expect them to write the application for you.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Thank You Sue for answering,

what i mean is that we go to the File-menu, choose Export and Import and

then go thru the choices that are before us. Like this we export the
calender enties that are not marked with private to a excel sheet, where I
have written a macro that sort the entries from the hole company (we are not
more than 12) and make a graphic illustration of the whereabouts of each
person. I also use comments to show details about the entry.

But anyhow, I do not have good enough VB skills to know how to start an

action given in the menu. With some more work I will find the solution, in
the end.

 

[Guest]

Sorry Sue that You find my question to wage. I have written a groupcalender that is working, and need no help with that. My only quets was to automate the operation File - Import&Export- Export file - ....... in the Outlook to spare my colleauges for the number of choices they have to make when exporting their calender entries. I sure will try to be more specific latter on.

 

[Sue Mosher [MVP]]

Outlook provides no technique for automating the Import and Export Wizard.
You would need to write your own export code.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sorry Sue that You find my question to wage. I have written a

groupcalender that is working, and need no help with that. My only quets was
to automate the operation File - Import&Export- Export file - ....... in the
Outlook to spare my colleauges for the number of choices they have to make
when exporting their calender entries. I sure will try to be more specific
latter on.