Printable View
In outlook it is possible to save your calender as an HTML page. the prompt box ask for an output file and a start and end date. I need the VBA code so I can build an excel macro that automatically pulls my outlook calender builds the HTML page and opens it. Anyone know where to find this code? Thanks
Finally verified it. You can not save a Outlook Calendar as a webpage at all as it is not exposed for programming under any Object Model (OOM, CDO, etc.).
One thing you can do is to automate the manual keystrokes or mouse clicks.
Or what you could do is to use Word's SaveAs HTML feature. If you connected to Outlook from Word and read in the calendar you could create your own calendar in Word using a table. Then when you SaveAs HTML is will convert it all to HTML.
thanks for the answer, is there a way to build a hyperlink to a shared calender through excel? My particular project is building a master link page...this link page pulls together all the data necessary to build a schedule. One of the peices of data needed to build the schedule is a shared calendar. Can excel hyperlink to a shared calender? Can that hyperlink be tailored to a specific date, or the system date?
Thanks
What version of Outlook are you running?
You can have Excel open a Calendar but to go to a particular date will take soem doing as the .GotoDate method is unsupported and buggy.
Office 2003