Add picture to Word Document

C

CityGuy

I am trying to add pictures via VBA to a word document.

I used the Word Macro recorder to generate the code
needed to attach the pictures. When I the Access routine
I get the error message "This is not a vaild file name".

The picture attaches if the file name looks like:
"filename"

If I change the code so that the file name looks like:
strQuote & strfilename & strQuote

I get the error message. What am I missing?
Note that the strfilename is about 110 characters in lengh,
is this the problem?

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top