+ Reply to Thread
Results 1 to 4 of 4

VBA to MOVE pdf files between 2 folders

  1. #1
    Registered User
    Join Date
    04-19-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    31

    VBA to MOVE pdf files between 2 folders

    Sorry to revive this thread. Need some help changing this code if possible please

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 03-08-2018 at 09:12 PM. Reason: Added missing CODE tags

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,274

    Re: VBA to MOVE pdf files between 2 folders

    Love your natural wording effort!

    try this
    Please Login or Register  to view this content.
    i think it could do with more error handling like yours but i cant come up with any in my test situation

    also the cell that has the path's must have "\" at end
    Last edited by humdingaling; 03-09-2018 at 12:41 AM. Reason: changed code to move instead of copy
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    4,448

    Re: VBA to MOVE pdf files between 2 folders

    Or you can add a check.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Registered User
    Join Date
    04-19-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: VBA to MOVE pdf files between 2 folders

    Quote Originally Posted by bakerman2 View Post
    Or you can add a check.
    Please Login or Register  to view this content.

    Bakerman - thanks for your help. I am going to test it out today. Will let you know the result.

    Natural wording - programming is just natural wording put into syntax isn't it :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1