Only run macro if file exists?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Only run macro if file exists?

  1. #1
    New Member
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Only run macro if file exists?

     
    Hello everyone, please can someone help me with the following..?

    I have a simple macro to open a seperate file and copy over some data.
    The macro is repeated several times for different files, six in total.
    Now I am trying to create a macro to run each of the six 'copy' macros, but to only run each macro if the relevent file exists. So if the file does not exist, it will not try to open it and copy the data over...

    Can someone pls let me know if this is possible?

    Thanks

  2. #2
    Board Regular btadams's Avatar
    Join Date
    Jan 2003
    Location
    Richmond, Va
    Posts
    1,913
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Only run macro if file exists?

      
    Welcome to the board!


    Check out this link:

    http://www.exceltip.com/show_tip/Fil...Excel/471.html
    “The early bird gets the worm, but the second mouse gets the cheese.”

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com