folders

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

HI All, I need help in writing a macro which will run in all sub folders. I have more than 75 folders in which it contains 8 excel workbooks each. one of the work book named " Summary" has the name in cell A1. I need a macro which will insert one column before column A in all workbook and...

Hi - Is there a way to search folders to open by matching just a partial folder name. For example: I want to use cell C1 as a reference for the folder name. So while C1 has the text "Peter Piper Picked", and the folder on the drive is titled Peter Piper Picked (12 Pickles), it would still...

I found this solution elsewhere on Mr. Excel to (hopefully) tackle a project I was wanting to take on. I found this Ron de Bruin automation macro and I want to copy files from a mound of floppy discs to a location on my PC. The problem I am encountering with the code is that if I want to copy...

I am using the age old loop through the controls ie. For Each cCont1 In Workshop.Frame2.Controls If TypeName(cCont1) = "TextBox" Then etc., etc. My question is "How do I identify the frame that the control resides in?" I have 10...

Hello, I have a problem in that I have found a template with code that searches folders and sub folders for selected file types and returns the file path, date last modified etc. then in the last column it generates a link to the file, this is great for me but not for my collegues, the problem...

Hi, I have large number of folders inside which I have subfolders (child folders) that I would like to move them to a new subfolder 2018 (macro should create it). In summary I need to archive all these subfolder inside each folder to a folder of last year 2018. Thanks for your help :)

Hi All, So i have a VBA code that lists the number of files in a specific directory However, can this VBA code be evolved to have the following, 1) List the number of folders and Sub-folders 2) List all the files in these folders and sub folder Would be beneficial if the each Macro provides...

Hi could i have a multiple VBA code to do the following 1) Grab a list of folders and the file names in a folder i specify by a cell reference 2) a macro to change the file names 3) A macro to create folders and put these file names in there? a message box detailing the number of files...

Hi I'm looking for a VBA code to create subfolders. Ideally the code should pick up the file location from a cell (as there will be multiple users with different gile dirctory saved) and then I have a list in column A of file names that I would like to create folders and at the end the...

I want to export a list of all folders on our FTP server to Excel. Can I do this and, if so, how?

Hi, I have two folders containing different versions of the same workbooks. The names of the files are identical. I need a script that would identify workbooks with the same name and copy Worksheet 1 of Workbook 1 AFTER Worksheet 1 of Workbook 2. Can this be done? The folders have hundreds...

So I have ~5 folders with 4-8 files within each. These all reside in another folder location. Is there a quick snippet of code that will navigate to this location and list the name of the workbook/file?

Hello! First, thank you for reading. I've used VBA tons of times in the past to make my life easier, but now I'm actually studying Programming to get a degree in it so I know what it is that I'm doing instead of recording macros or modifying code. The issue is that at this point in my studies...

Hi all, Quickly : There are folders for each month of the calendar year and in those month's folders are sub-folders which belong to various companies. In the company's folder are more folders which holds .txt files that I need the the contents to be extracted from. Essentially, in folder "03...

I am work events where photographers are sorting their pictures into folders based on the Routine number while at the event. But each routine also has a unique ID number that is never repeated that is actually used internally back at the office. So I was wondering if I had an excel sheet that...

Essentially, I want to be able to highlight a list in a column and run the macro. The end result would be that the macro would allow me to browse for the desired folder and within each sub-folder of the desired folder, a file for each name on the list will be created. For example, I want to...

Hi Guys, Need a code which list the full file path of all folders, sub folders and files held on a shared drive and writes the results within excel. So basically everything stored on the drive. example: Column A C:\new folder\test.doc C:\new folder\test2.xls etc. There are a lot of files on...

I haven't used VBA in about 2 years, and I lost my logical mindset, when it comes to the syntax for programming in Excel. Anywho, I have a make shift code for renaming folder(s), but I need help with VBA to allow me to choose a folder (not subfolder), preferrably in a window, in a specific...

Is there a way that I can connect powerquery to one main network folder, then pull in any excel file that is in that network folders sub folders? I am trying to come up with a budgeting tool for my company, I want to give each cost center their own network folder that they can access to enter...