Excel Open pdf from excel


Joined
Nov 10, 2007
Messages
2
Reaction score
0
I would like to open external pdf files from a cell inside an excel file. I can get this to work with hyperlink the problem is that some of my pdf files have #1 or #2 in the filename and Hyperlink will not work with "#" in the name. If I take it out it works fine. But I have 100's of files that I want to open and some have the # and some do not.
Is there a wildcard I can use for the "#"

Should I try something other than hyperlink?
Here is an example

C:\testfile.pdf Cell A1
C:\testfile#1.pdf Cell A2

=HYPERLINK(A1,"Open") Works great
=HYPERLINK(A2,"Open") Cannot open file

Please help!!!!!!!!!!!!!!!!!!!!
 
Ad

Advertisements

Ad

Advertisements

Joined
Nov 10, 2007
Messages
2
Reaction score
0
I wish I could

I cannot because the program that creates these will update them all of the time and I will not be able to track all of the updates.
 

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

Similar Threads

Word From PDF to Word copy & paste issue 4
Excel Convert excel sheet to pdf, faulty vba code 0
Outlook Outlook Express 6 does not open pdf files correctly 0
Word PDF to Word (or similar) 9
Save as PDF in Office 7
Access access pdf printer 0
Access Fillable Access PDF Reports 0
Word Word 2007 PDF query 0

Top