I would like to open a pdf file on m disk drive from a cell. I can get
hyperlink to work but the program that generates the pdf adds #1 to
the file if it has been revised. So I have file like this

C:\testfile.pdf ( which works)
C:\testfile#1.pdf (does not wotk with hyperlink)

=HYPERLINK("C:\testfile.pdf","open file") this will work

=HYPERLINK("C:\testfile#1.pdf","open file") this will not work

The problem is the "#" character.
Hyperlink does not like wildcards or I am not using the right format.

I have over 500 files and more than half hve the #1 or #2 or #3

Is ther another way to open the file other than hyperlink?

Any ideas? This is the 3rd excel group I posted the question to with
no answers.

I would appreciate any help on this.

Thanks