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 |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com