Copying files to a new location

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • anthony
    #1

    Copying files to a new location

    Is there a way, using code, to copy files from one location to
    another? I have a table with the filenames so, having defined the path
    to the folder, I then need to copy the relevant files and paste them
    into a new folder. Any ideas please?
    Tags: None
    • Stuart McCall
      #2
      Re: Copying files to a new location

      "anthony" <anthony.marria n@gmail.comwrot e in message
      news:13bca13e-a92c-4702-ab27-810fe24951be@k3 0g2000hse.googl egroups.com...
      Is there a way, using code, to copy files from one location to
      another? I have a table with the filenames so, having defined the path
      to the folder, I then need to copy the relevant files and paste them
      into a new folder. Any ideas please?
      Check out the FileCopy statement in help.


        Comment

        • lyle fairfield
          #3
          Re: Copying files to a new location

          anthony <anthony.marria n@gmail.comwrot e in news:13bca13e-a92c-4702-ab27-
          810fe24951be@k3 0g2000hse.googl egroups.com:
          Is there a way, using code, to copy files from one location to
          another? I have a table with the filenames so, having defined the path
          to the folder, I then need to copy the relevant files and paste them
          into a new folder. Any ideas please?
          Copy
          FileCopy "C:\Users\l yle fairfield\Docum ents\Excel\ks95 9.zip", "C:\Users
          \lyle fairfield\Docum ents\Access\ks9 59.zip"


          Move
          Name "C:\Users\l yle fairfield\Docum ents\Access\ks9 59.zip" As "C:\Users\l yle
          fairfield\Docum ents\Excel\ks95 9.zip"

            Comment

            • anthony
              #4
              Re: Copying files to a new location

              On 24 Jul, 11:33, "Stuart McCall" <smcc...@myunre albox.comwrote:
              "anthony" <anthony.marr.. .@gmail.comwrot e in message
              >
              news:13bca13e-a92c-4702-ab27-810fe24951be@k3 0g2000hse.googl egroups.com...
              >
              Is there a way, using code, to copy files from one location to
              another? I have a table with the filenames so, having defined the path
              to the folder, I then need to copy the relevant files and paste them
              into a new folder. Any ideas please?
              >
              Check out the FileCopy statement in help.
              That is just the ticket. Many thanks!

                Comment

                • anthony
                  #5
                  Re: Copying files to a new location

                  On 24 Jul, 11:56, lyle fairfield <lylef...@yah00 .cawrote:
                  anthony <anthony.marr.. .@gmail.comwrot e in news:13bca13e-a92c-4702-ab27-
                  810fe2495...@k3 0g2000hse.googl egroups.com:
                  >
                  Is there a way, using code, to copy files from one location to
                  another? I have a table with the filenames so, having defined the path
                  to the folder, I then need to copy the relevant files and paste them
                  into a new folder. Any ideas please?
                  >
                  Copy
                  FileCopy "C:\Users\l yle fairfield\Docum ents\Excel\ks95 9.zip", "C:\Users
                  \lyle fairfield\Docum ents\Access\ks9 59.zip"
                  >
                  Move
                  Name "C:\Users\l yle fairfield\Docum ents\Access\ks9 59.zip" As "C:\Users\l yle
                  fairfield\Docum ents\Excel\ks95 9.zip"
                  Thank you so much Lyle

                    Comment

                    Previous template Next
                    Working...