filecopy

  1. A

    Copy and rename a file with partial name start and end name

    Hello all, I typically move a number of files using VBA using very simple code (sometimes its FileCopy instead of NameAS): Name Sheets(2).Range("F26").Value As Sheets(2).Range("F27").Value The cells values that the code references typically look like this...
  2. Z

    Fastest way to put files in a network folder / saveas or filecopy?

    I want to save Excel files in both the local drive and in the network folder. Currently I am doing it with SaveAs (local) and another SaveAs (network), is it faster to do a SaveAs then FileCopy? Code below: Sub SaveAs() Dim ws As Worksheet Dim ws_console As Worksheet Dim...
  3. M

    Copy Single file to multiple destination in easy way...?

    Hi, I want to backup my log workbook to multiple locations. How can i do it in simple way.? right now i only back to one location and here is my code. I am not a programmer but by seeing different posts i created this "sub". Sub BackupTaskInfo() FileCopy "X:\Startup\Tasks Info_2018.xlsx"...
  4. M

    FileCopy Error 52 Bad File name or number

    I'm trying to do something that I thought was straight forward. I'm trying to move and rename a file from one folder to another. After doing the Google search I found: Sub Move_Rename_One_File() 'You can change the path and file name Name "C:\Users\Ron\SourceFolder\Test.xls" As...
  5. N

    VBA to loop through a range and copy documents based on variables.

    Hi, I've referred to this site numerous times over the years and it has been very helpful so firstly I would like to say thanks. Generally I've not needed to post a question before as I have generally been able to use the information in the various posts to figure out what I have needed to do...
  6. P

    vba wildcard - FileCopy

    Hi I'm using the FileCopy function to copy files from one location to another. I would like to change slightly so that I can use a wildcard For example: \\homedrivestmp\homedisk1\saery\Desktop\test250118.xlsx Rather than specify the file name as above, I would like to target files where the...
  7. D

    Copy file and paste file with filename stored as variable VBA

    Afternoon All, I am trying to copy a file from one location to another. Just use FileCopy right? Well urmm no? The issue I have is that the file that is copied changes and therefore its name address and extension can change. Its full address is saved as a variable. I am trying to paste it in a...
  8. A

    Keep GetOpenFilename in memory while adding a link and performing a copy/paste to SharePoint with appended filename

    Hello folks, This should be an interesting topic. I did research and managed to create a series of Subs that Upon double-click in a column cell Prompted Application.GetOpenFilename (opening a file explorer window) Applied full file-path in the cell as a hyperlink...
  9. B

    Filecopy For transfering files

    Hi, I was wondering if anyone knows if the macro continues when you use filecopy or does the macro wait for the file to finish copying before moving on to the next line of code?
  10. E

    Copy file that is open

    Dears, Do you know How to copy file in VBA if the file is open? FileCopy doesn't work Have a good day. Piotr
  11. V

    VBA Copyfile with admin rights

    Hi all I have a simple line of code that doesnt work because I meed admin rights to place file there. Anyone able to help me to resolve please? File location to copy from:C:\Users\User1\Documents\Work\ Destination path: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup Code...
  12. M

    "Bad file name or number" when FileCopy

    A1 has some Chinese text When I change the text in A1 to English it works fine It doesn't work with the Chinese text How do I fix this?
  13. D

    Loop to copy files and deposit into another location

    In an answer to a previous post, AlphaFrog gave me the following code that allowed me to loop through subfolders called 'Pricing' and change data in a cell in the one file in that folder. What I'm trying to do now is instead of manipulating the contents of the excel file, I'm trying to copy...
  14. J

    Excel (2007) VBA - Filecopy only files listed in an excel sheet to different specified folder path

    Good Morning! I have an upload sheet which contains the following Column A will contain either Y or N, Y if the file is to be copied upon run macro or N, if needs to be ignored Column B - path and file name to be copied Column C - destination path I've been trying to figure out how to code...
  15. M

    Copy hyperlink content (.pdf) to a destination folder

    Hi! I have a sheet with several hyperlinked documents. With using a filter function I can get a list of documents that I want to print out. So I need a macro to look at each hyperlink and find the filepath and name, copy the file to a destination folder like C:\test\ There is something with...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top