Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PDF differance in Excel 2002 & 2003 (Excel 2002/3)

    I have the following text in a cell: =IF(FileExists("NetApp2SharesFinanceConfidentialsD atabaseScanned Contracts"&A4&".PDF")=TRUE,HYPERLINK("NetApp2Share sFinanceConfidentialsDatabaseScanned Contracts"&A4&".PDF","Contract View"),"Not Scanned")

    In Excel 2002 it opens the pdf document but in Excel 2003 it opens a blank Acrobat session. Are there somewhere a setting to change to allow the view of the PDF document. I might add that the Excel 2003 was a brand new pc installation

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PDF differance in Excel 2002 & 2003 (Excel 2002/3)

    It's not a problem in Excel 2003 itself - similar formulas work without problem on my PC with Excel 2003.
    Check the association for the .pdf extension on the problem PC.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF differance in Excel 2002 & 2003 (Excel 200

    I've been there. If I put the file extension in Windows explorer it does open in Acrobat with the right file showing The only differance is that on the old pc it has a pdf1 extension as well. Am I right in stating that if I have a link or file with the PDF extension and when I click on it it show in Acrobat surely it should do the same in Excel. Any more ideas will be appreciated

    TIA

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PDF differance in Excel 2002 & 2003 (Excel 200


  5. #5
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF differance in Excel 2002 & 2003 (Excel 200

    Thanks you've saved me again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •