How to extract file names/path from OLE Objects

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Hi,

I have a database that stores OLE Objects. That is, the
field 'WordFile' is of type "OLE Object" and it contains a
link to an MS word file. The database is becoming very
large due to all the links. I would like to replace these
links with a field containing the file name/path and some
code to spawn Word. (Which I have developed and seems to
work.) My problem is "extracting" the file name from the
OLE Link. I have attempted to access the object stored in
the 'WordFile' field but can't seem to get at the Word
properties, etc. I can activate the object (Me!
WordFile.Action = acOLEActivate) but that is as far as I
can get.

Thanks,
Don
 
Back
Top