Re: Getting Excel file properties Using Outlook

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Download the dsofile.dll from:
http://support.microsoft.com/kb/224351/en-us

In the text it's said that the library can be used from any COM-aware
language.

--

Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Am Tue, 14 Nov 2006 01:22:01 -0800 schrieb Gleiken:

They are returned to a central mailbox and currently I have a macro that
saves the files to a folder dependent on filename (I can get that one
easily). However, users keep changing the filenames (as people are
inclined
to do) so I end up going through a large proportion of them each time
(around
10% of 500 every other day).

The Subject I'm talking about is held within the File properties of an
excel
file that you see by selecting properties from Explorer or within Excel
itself. I know how to retrieve this when the file is open but I don't
want
to open the file from the email (due to server delays it would take far
too
long) and then retrieve it.

I was hoping there would be some way to retrieve this via Outlook without
opening it. This would mean I could add the correct filename into the
subject of the Excel sheet when it's generated and then I wouldn't have to
worry about people changing them.

"Michael Bauer [MVP - Outlook]" wrote:


Where do you get the files from? Is the subject the filename?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Am Mon, 13 Nov 2006 06:52:01 -0800 schrieb Gleiken:

I'm trying to retrieve the Subject property of an Excel file using an
Outlook
Macro. This will then be used to determine where a file should be saved
as I
have problems with users changing file names when they shouldn't. Does
anyone know how to do this without opening the excel file? I'd rather
not
do
that as I'm talking about hundreds of files at a time and can't be
bothered
waiting for our server to catch up

Using Outlook 2002.

.

Relevant Pages