How do I attach a document along a column?

[ae030]

I have written a code where a user can enter text onto textboxes and
these will be written on a respective row, below is an example.

Name Location Email
Document

John Doe Houston (e-mail address removed)
Document1.doc

So the problem I'm having is attaching documents in column 4 (in this
example Row2 Column4), I just want a simple icon, or anything really
that makes this work, to show up in that cell and then have a user just
be able to double click it and launch the document.

 

[Simon Lloyd]

Why not create a hyperlink to the document

I have written a code where a user can enter text onto textboxes an
these will be written on a respective row, below is an example

Name Location Email Documen

John Doe Houston (e-mail address removed) Document1.do

So the problem I'm having is attaching documents in column 4 (in thi
example Row2 Column4), I just want a simple icon, or anything reall
that makes this work, to show up in that cell and then have a user jus
be able to double click it and launch the document

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[ae030]

Why not create a hyperlink to the document?

heh heh, that's very clever. The reason why I can't do that is because
others besides the originator will be using it. How can they access a
file that's within my hard drive?

 

[Simon Lloyd]

heh heh, that's very clever. The reason why I can't do that is becaus
others besides the originator will be using it. How can they access
file that's within my hard drive?well i probably got the drift that that is what you wanted as you saidae030 Wrote:
I just want a simple icon, or anything really that makes this work, t
show up in that cell and then have a user just be able to double clic
it and launch the document.it seemed to me that you do want them to open the document, a hyperlin

does this, if thats not what you want can you explain a little furthe
what you are trying to do

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[ae030]

well i probably got the drift that that is what you wanted as you saidi
seemed to me that you do want them to open the document, a hyperlin
does this, if thats not what you want can you explain a little furthe
what you are trying to do?

I want them to be able to open the document. I think if I used
hyperlink the user of this would not be able to open the document as i
would be linked to a document on my hard drive, which they will not hav
access to. Also, the document that will be attached might chang
locations from where it is initially located

 

[Simon Lloyd]

I want them to be able to open the document. I think if I used
hyperlink the user of this would not be able to open the document as i
would be linked to a document on my hard drive, which they will not hav
access to. Also, the document that will be attached might chang
locations from where it is initially located
--- Automerged consecutive post before response --
I tried using an OLE Object, but I was unable to link it to a cell.Create a hyperlink to the attached document, im assuming you are sendin

a document that will be saved on the users pc, and if the document i
going to change locations there's no way of tracking that

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[ae030]

Create a hyperlink to the attached document, im assuming you are sendin
a document that will be saved on the users pc, and if the document i
going to change locations there's no way of tracking that.

well can't an OLE Object accomplish that. Let's say that I hav
selected a file and attached it to the spreadsheet, can't the documen
still be opened even if the original is deleted? I guess my question no
would be, how do I link an OLE Object to a cell (i.e. D2). That way whe
someone tries to pull up a record they can see the name, location, emai
and that document that is associated with name, location, and email