Copying cell value to clipboard to paste into adobe pdf maker

[Jooer]

After trying unsucessfuly to manipulate pdf maker to
allow me to tell it what file nae I want it to save my
pdf as, programatically, I have been resigned to
automating the printing process but copying the wanted
file name to the clipboard so that the user can paste it
into the filename space on pdf maker.

As I note from several other threads however this is not
easy. I still cannot make it work using the ideas
suggested. I have used the Range.Select and
Selection.Copy but that doesn't work. (The name of the
file that I want is stored in a cell).

Any ideas?

Thanks.