sourcepath

  1. W

    Copying files to specific folder

    I've put the following code together to copy specific files from one folder to another based on a list contained in a spreradsheet. There are 2 problems which I'd appreaciatte some help with 1 the kill instuction doesn't work and 2 the code is copying all of the files, not the ones...
  2. S

    VBA code - Moving files not working

    i have a list of files in column d that i would like to move as per col e however nothing is copying over......can someone please help?
  3. B

    vba code-copy files from folder and sub folders

    hi everyone, I now its a mainstream thing that I am writing now in fso systems but I am trying to learn "how I would do that" thing, can you please help with the below code? It does not give any error message or something but it is not copying any materials to destination. Sub...
  4. S

    Looping a macro

    I have a macro goes through a single process. I would like to add a loop to the coding to read through a list on a spreadsheet and go through the process multiple times. Here’s what I have. “L1” and “E1” refer to cells on the spreadsheet Sub FindFilename() Dim FSO As Object Dim sourcepath...
  5. B

    Excel VBA File Copy

    Hello, I am looking for some help copying from a source file to a destination file. sourcePath = Sheet1.Cells(121, 9).Value Source Cell: (121, 9): "C:\Desktop\Proc_9UL_RB_10\MCD_9UL_RB_10" DestinationPath = Sheet1.Cells(110, 13).Value Destination Cell(110,13)...
  6. B

    Excel VBA FSO.copyfile Source

    Hello, the current code below copies files from the source folder to the destination folder based on cell value and file extension. The files may or may not be used all the time, if the file is not in the source folder I am getting an error. I would like to add code that will skip to the next...
  7. B

    Excel VBA File Copy

    Hi, I have a macro I am working on and would like to get some help. I am trying to copy files from one folder to another folder based on a partial file name. Here is the code I am currently using. It copies the entire contents of the folder (not what I want). Private Sub...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top