+ 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
    33

    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,636

    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
    MO Prof Plus 2016
    Posts
    6,907

    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
    33

    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)

Similar Threads

  1. Auto move the files to desired folders
    By mylai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2017, 09:50 AM
  2. [SOLVED] Create Folders and Move Files
    By ascool_asice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2015, 06:50 AM
  3. [SOLVED] VBA to MOVE pdf files between 2 folders
    By sparx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 03:53 PM
  4. Move Excel files from multiple folders to one
    By Azzzman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2013, 10:21 AM
  5. How to Move specific files to folders with VBA
    By EnzioL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2012, 06:46 AM
  6. Create folders and move and copy files into that folders
    By vijaybharthi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2010, 04:01 AM
  7. Create Folders and Move Files Using VBA/MACRO
    By cjconnor24 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2010, 07:20 PM

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