file copy

  1. T

    Macro to Save a copy of the Workbook to a specified location on OneDrive for multiple users.

    Our company uses Onedrive for our team file distribution. All work is done locally and then files are synced up when wifi is available. I have a few macros built in to our files to ready them for client distribution. The problem is sometimes the files get overwritten after the macros run and we...
  2. A

    Translation for File Copy In OneDrive

    We recently migrated our files to OneDrive. Our previous use of Path would render a windows address string. It now renders the url of the cloud file location. When using the link, the path opens the url in an explorer window requiring another authentication. We currently have the cloud...
  3. T

    How to provide a file progress bar when downloading a large file

    I have this code that opens a workbook on a local website on our intranet and then copies the sheet into a local file. Workbooks.Open ("http://teamspace.****.com/sites/****/****/Shared%20Documents/Lookup.xls") LastRow = ActiveSheet.Cells.Find("*", , xlFormulas, xlPart, xlByRows...
  4. A

    Help Needed for Data Extraction from Hundreds of Zipped Files!

    I'm now in a headache to extract data from files and really wish somebody could help me out of this. The problem is that there is a directory, e.g. I:\john In this directory, there are 100 zipped files. In each zipped file, there are 26 different .csv files. I only want to extract the data...
  5. M

    excel rename file from list error

    I am not an expert nor do I have much experience with excel. Here is what I am trying to do: I have some master template files in a directory. I want to Rename the files in the Directory but keep the old files. I have a spreadsheet that lists the files in column A and Column B has the new name...
  6. H

    Macro to Copy PDF Files to Destination folder based on cell information

    Hi Everyone, I'm looking for one assistant....I have folder which contains 100+ PDF files and these file names I have it in my excel say it start from A2 cell... I would like to move PDF files to different folder based on PDF file name which is there in the excel sheet.... For Example: If A2...
  7. F

    VBA- Selecting file to copy a range into existing sheet

    Hi all, I'm trying to accomplish something that I can't seem to figure out in VBA. It's a little hard for me to explain, but I will try my best. What I want to do is prompt the user with a Windows Explorer window to browse for a file. The file that the user navigates to will be a .csv file...
  8. C

    File replication/copy and find replace text/numbers within doc

    Hi , i have a word doc that i need to replicate/copy multiple times. I need only to change three numbers in the header of the word doc that will be supplied for the rest of the docs through an excel file with 3 columns holding the new set of numbers to be added to different cells in the word doc...

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
Back
Top