Consulting

Results 1 to 2 of 2

Thread: Checking for file presence

  1. #1
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location

    Checking for file presence

    I have a form that shows one row of data like a record in a database. One of the cells is a primary key. Each time I go to the next row (record) I would like to see if there is a pdf file using the primary key. For example: if the primary key for the current record is 6421, I want to see if there is a file 6421.pdf and then create a hyperlink to that file on the form. Also is there a help file available for adobe controls?
    Last edited by ProteanBeing; 12-27-2007 at 10:59 AM.
    "The amount of stupid people in the world is God's way of punishing the smart people" - protean_being

  2. #2
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    You can use Dir("path and file name") to check if the file exists. If it doesn't, Dir will return ""
    If there is a help file, Adobe would provide it - check the program directory (or the Adobe forums).
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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