Extracting Media objects from RE using VBA

Adrian Jones

Hi

I have a number of constituent records in RE7, with media items attached, and I need to extract all of the media files.

I'm able to get to the media object, with VBA, using:

oRecord.Media.Item(i).Fields(MEDIA_fld_Object)

But the byte array that it returns appears to be the document packaged in an OLE wrapper.

Does anyone know of a way to strip off the OLE wrapper in RE VBA?

Thanks in advance,

Adrian

John Heizer

Adrian Jones:

Hi

I have a number of constituent records in RE7, with media items attached, and I need to extract all of the media files.

I'm able to get to the media object, with VBA, using:

oRecord.Media.Item(i).Fields(MEDIA_fld_Object)

But the byte array that it returns appears to be the document packaged in an OLE wrapper.

Does anyone know of a way to strip off the OLE wrapper in RE VBA?

Thanks in advance,

Adrian

 

Blackbaud has obviously found some way to do this (probably not VBA, but some sort of automated method) to be able to take Media files in RE SQL and move them to NXT.  It would be nice if they'd share that with the rest of us.

Alex Martin

Where you able to accomplish this?