1. B

    How to copy from different files and maps based on the week number in VBA

    Hey everyone, I would like to make a macro that searches every folder within a folder that has a folder with the current weeknumber in it (let me explain). - I currently have a folder with the names of each of my colleagues as seperate folders and 1 folder that is titled "archive". - Every...
  2. P

    Excel VBA New Folder and copy an existing folder based on a cell.

    Good Afternoon, This seems to be a pretty common request, and I have tried other codes in other threads, but none of them are exactly what I am looking for. Heres the Goal: Create a new folder in a particular part of my server (This changes based on the information they put into the...
  3. T

    Forcing folder creation

    Hello everyone, I am using a script that will save a file to a specific folder based of a couple of cells. If the folder doesn't exist, the command fails. I cannot figure out how to get it to create the folder if it isn't there. Here is what I am using now: Sub File_Save() Dim Path1...
  4. P

    Automatically Adding to a list when a folder is created?

    Good Morning, What I am looking to do might not even be possible, but I am hoping that it is, even if I have to try and figure out Access to make it work. I work for a construction company, and the way we add jobs to our server is: Job number - Job address - Job name example 1500 - 123...
  5. I

    Search for files that contain keywords in folder + subfolders

    Hi Everyone, Quite new to VBA and would really appreciate some help please ? I have a macro in a workbook that when ran, scans a drive that the user selects and looks for all files that contain the keyword provided. Is there anyway to: 1. Get it to scan also the subfolders within the folder...
  6. I

    Search for a Sub-folder on another Network Drive

    Hi! I had a set of ~50 project folders (format e.g. 12345_Project_Name) which mere migrated to another server, but in the process were moved into different subfolders and in some instances were renamed, so I cant, for example, simply rename hyperlinks from \\drive_a\ to \\drive_b\. I've pulled...
  7. G

    VBA to collect data from different files to one file on different tabs(worksheets)

    Hi All, I am trying to get a vba code to copy information from different files to one destination file but on different worksheets on the destination file. The destination file is called "Master data file ". The master file has worksheets named ""Sheet1","Project1" , "Project2"...
  8. D

    Outlook VBA - renaming outlook folders using find/replace code that references excel workbook/sheet: it converted all folder text to lowercase

    Hi Folks, Basic issue: I have a requirement to rename many outlook folders/sub-folders and I thought I'd found the perfect outlook VBA code; however, I have two issues with it 1) it's changing the case of my outlook folders to lowercase 2) It's doing part matches. Detail The code below...
  9. A

    The HDD from the old PC

    I suppose this is the right forum for this topic, my apologies If I am mistaken. The story (introduction) Time came for some colleagues at work to get new computers. WinXP was obsolete by far. A new PC arrived with its own HDD and a not so old OS. The issue is: to transfer the files from the...
  10. M

    Moving Files from folders less than specific size

    Hi All, I'm after a program that will loop through all folders and files in a directory regardless of what file type they are that are less than a specific size lets say 15GB and move them to a folder that it creates on the desktop called the less than 15gb and the date and then go through the...
  11. F

    VBA to Rename Files within sub folders

    Hi I am looking for a VBA code to rename file names from column (a) to the new name in column (b) The original files are located in sub folders within a main folder so the VBA code would need to search in sub folders to replace the name. If anyone can help that would be amazing
  12. S

    Change the modified date of multiple folders from excel input

    Hey, I want to change the ""Modified Date"" of multiple folders in Windows Explorer as per date mentioned in Excel Cells. Thanks in Advance..
  13. Z

    List number of files in folders

    Looking for some help to make this code suit my needs. Goal is to list the number of files in several folders. The folder names are listed in column C and always hosted under "C:\Users\diego\test". The number of files should be displayed in column K. Below code works, but it ignores folders...
  14. Y

    Resave all files in folders and their sub folders

    Please, what's the fastest code that can resave (perhaps through loop) all the files in a folder and its subfolders and it will maintain the folder and subfolders structure in their destination?
  15. L

    File Path By Year and Month

    Hi, I have this code for file path for the Invoice PDF. Private Sub CommandButton1_Click() Dim NxtRw As Long, CurrentPath As String, wFile As String On Error GoTo EnEvents If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If...
  16. A

    Creating Folders with VBA

    Hi all, I have been reading all posts but cant come across the answer. I am using this code: Sub createFolders() Dim fpath As String Dim i, xc As Integer For i = 1 To ActiveSheet.UsedRange.Rows.Count xc = Range("XFD" & i).End(x1ToLeft).Column If xc = 1 Then fpath =...
  17. I

    Create folder name with timestamp and create 4 additional folders within new folder help.

    Good evening, Is there a way using macro to create a month folder with a time stamp? The folder name will be the month name in cell B3 of sheet1 and can the time stamp be HH:MM:SS? Lastly can the macro create 4 additional folders within the newly created folder, if that is possible. The four...
  18. R

    Looping through folders within Outlook

    Hi all, I've been asked if I can create a macro that loops through a number of email folders within Outlook and saves the contents to a location on a network (ideally it would then clear the contents of those folders within Outlook). I was just wondering if anyone knew, initially, if this was...
  19. I

    Paste excel doc to many folders

    Hi, is it possible to paste an excel doc to many folders. Currently im doing it manually to each & every folder which takes up to much time. It would also need to overwrite the same named file in the folder its being pasted to Thanks
  20. D

    Macro to download outlook attachments not working

    Hi, I need to download lots of attachments from various folders in outlook and trying to use the code below. The issue is that on some folders it works just fine but for others i get a runtime error 13 on the line in red. Any ideas on why that's happening? Also, is it possible to ammend the...

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
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 "".
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