convert an OLE column into a Hyperlink
Posted on 2005-04-12
OK guys. Please don't leave me hanging on this question because this is probably the most important one I'm going to ask of all.
I have a column that is setup to accept OLE objects only.
I want to convert any data that has been entered as an OLE and get the "path" of the object instead.
Then I want to change the column to a hyperlink.
If at least I can create a temporary table (tempMEDEQ) to do this would be easy for me, probably an exact copy of MEDEQ.
Already change the tempMEDEQ's column from OLE to Hyperlink
And as I go through each row of MEDEQ if there is an OLE object, I would grab the "path" of the object and store it in the matching autonumber of tempMEDEQ's new hyperlink column.
What VBA command can tell me the path of an OLE object?