+ Reply to Thread
Results 1 to 4 of 4

VBA Macro or Formula to copy file (PDF) to other Folder

  1. #1
    Registered User
    Join Date
    08-26-2020
    Location
    Bruges, Belgium
    MS-Off Ver
    Office 365
    Posts
    2

    Question VBA Macro or Formula to copy file (PDF) to other Folder

    Hey there,

    I'm looking for a Formula, or a VBA Macro, to copy a file from a folder to another folder, easy to use.
    I did let VBA make the path of the file that exists, and the destination-path (file).
    I've tried serveral codes from the internet, but i can't figure out how to get it working exactly as i want it to do so.
    My idea is to keep it simpel, and let the code work if there is an "x" placed in the row of the Invoice.

    Keeping in mind that every Invoice comes in that list, so fixed formulas won't work i guess.
    How can i get that 'x' - idea working? Or any other suggestions?

    See more information at the attachment.

    Thanks in advance!
    Thomas
    Attached Images Attached Images
    Last edited by Thomatter; 08-26-2020 at 04:05 PM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA Macro or Formula to copy file (PDF) to other Folder

    to copy a file....this question has been asked many times here, and elsewhere. have you tried this?

    www.google.com/search?q=vba+filecopy+method

  3. #3
    Registered User
    Join Date
    08-26-2020
    Location
    Bruges, Belgium
    MS-Off Ver
    Office 365
    Posts
    2

    Re: VBA Macro or Formula to copy file (PDF) to other Folder

    I did look at it, but i struggled with adding the IF code for the X to comfirm to copy...

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA Macro or Formula to copy file (PDF) to other Folder

    what IS the code you used? keep in mind that I've answered way too many questions lately...

+ 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. Macro to copy server file into local folder, and change data sources to this new file
    By rickywangca in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2019, 11:18 AM
  2. [SOLVED] Macro to Copy excel file from a location to a folder on Desktop
    By harish.chinni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2013, 02:17 AM
  3. Macro to copy the value of some cells in excel files in a folder to a master file
    By phemocheee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 08:33 AM
  4. Batch file & macro to copy the latest file from a folder
    By paidlukkha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2013, 03:05 PM
  5. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 AM
  6. Macro to copy data from one file to another in the same folder
    By chichapher in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-28-2012, 01:11 AM
  7. Copy and move file to a new folder: macro
    By mdaga in forum Excel General
    Replies: 2
    Last Post: 04-10-2008, 02:55 AM

Tags for this Thread

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