K
Kulcha
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
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