error in attaching pdf file

[shido]

Hi all,

Wondering if anyone can help me.

I am trying to add pdf file in cell i2 based on serach criteria in cell h2. if serach matches critera, attach file, else return message in i2 that file is not present.

Please Login or Register  to view this content.

Thank you

[natefarm]

Please Login or Register  to view this content.

[shido]

Hello Natefarm,

Thanks for your reply.

i am getting error when i try to run the code. please see the screen shot.

Please Login or Register  to view this content.

[/ATTACH]

[Norie]

You can't 'add' a PDF file to cell.

If you want to import the PDF file to the active sheet use this.

Please Login or Register  to view this content.

[shido]

Thanks Norie for the reply

I used your code but getting run time error.

please see attachment for the error

Untitled222.png

[Norie]

Have you checked the path and filename?

Does it work if you replace Strfilename with the hard-coded path and filename?

[shido]

Hi Norie,

its working with hardcoded path but when replaced with strfilename, its giving error.

Please Login or Register  to view this content.

Regards

[Norie]

Have you checked the value of fName when you get the error?

[shido]

hi Norie,

Thanks for your help. i just remove set obj before the statement and its working now.

Regards.

[shido]

Last question, can we file to be attached in a particular cell say "i2".

[Norie]

You can't really attach a file to a cell but the code I posted places the file over I2.

[shido]

Hi Norie,

I cannot able to post over I2. seem like

Please Login or Register  to view this content.

not doing anything.

[Norie]

What was the error when you used Set obj?

How exactly did you try the code I posted?

[shido]

Hi Norie, i used the following code. The error i am getting is attached below.

Please Login or Register  to view this content.

Untitled.jpg

[Norie]

Which sheet is active when you get that error?

Is it that sheet where B2 contains the name of the PDF file you want to embed?

Also, where is the code located and how are you running it?

[shido]

Hi Norie,

I have sorted out myself. Thanks for pointing me out to the right direction. The correct code is as follows,

Please Login or Register  to view this content.

Regards