Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Outlook calendar files in Excel
Hi
I asked this question recently on the misc group, but the thread got hi-jacked. I hope somebody here can help: For a few years I've used Excel VBA to look at an Outlook Calendar directory on an Exchange server. The code does a filesearch and lists calendar appoiintments that it is interested in from the subject line. The files have the .eml extension. It then selects each file in turn, opens it, extracts the information it's looking for and closes the ..eml file. This worked fine under Office 2000. We've recently moved to 2003 and Excel will not now open the files. In fact it 'opens' a blank file, of about 4k. It also fails to close it again! Even if Excel is used to open the .eml files manually the same happens, so it's obviously a feature of either Office or Excel that the status of the .eml file is being read differently. They still open fine using Excel 2000. Does anyone know what has changed? I've tried using OpenText and various other options but nothing seems to work. I can copy the files to a local drive, rename them as .txt and Excel 2003 will open them! Grateful for any insights! _ Kulcha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel and outlook calendar | Excel Discussion (Misc queries) | |||
Opening files from Outlook/Explorer to separate windows in Excel 2 | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
Opening Excel Files from Outlook | Excel Discussion (Misc queries) | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |