folders

Hi Everyone Sub OpenLon() StoreName = "Londonf" On Error Resume Next Kill "S:\" & StoreName & "\New Documents Folder\*.TMP" On Error GoTo 0 End Sub The above code works great for removing TMP files from "New Document Folder" Is there a way I could get it to run on all folders in "S:"...

Hi experts, Hope someone can help with this. I have 10k images named as AA-1000.jpg or AA-1000-10.jpg etc. The important thing is that I want to create folders based on first 2 letters in image names, and move all other images with same letters to the same folder. Basically, I want to run a...

im sure this is something people have wondered about or could use. i have an outlook inbox that is full of subfolders and i manually organize the emails because auto filtering just wont work for my needs. I drag 'n drop emails into the specified folders. i was wondering if there is a way to...

Hi) Can I use a VBA code to create certain folders in a directory? I want to create folders with the following names: 2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016. I also want to create subfolders in each of this folders with the following names: 01,02,03,04,05,06,07,08,09,10,11,12...

I searched and searched for a way to find and open a folder that contains a certain string. The key was HERE, thanks so much to Jerry Sullivan. Beyond that, my problem was, that I needed to find a string in a folder name with one wildcard, then within it, find a sub-folder with another...

Hi, I need to list the properties of a folder and it subcontents. The VBA I have works perfectly apart from one thing! I really need to add something to add an additional column detailing the content author of each folder or subfolder. Any help would be greatly appreciated! The VBA which...

I need to be able to list all files in all folders and subfolders in a particular drive (I use this macro to populate three different tables depending on the drive, so thus the mytbl and myPath variables. I also have it set to use a named range to determine whether or not to include...

Excel Guru's :pray: I have approx 30 excel files that I need to move to different folders based on the file name. The folders that these files are being moved to already exist. I have some code but it only moves one file, I need help adjusting the code to move all of them to their corresponding...

I have a template that I need to create multiple files from, so I created a macro that will run through a column of state names and save the file as the particular state name in the state folder. It starts on cell (5, 35) and continues in a loop to (55, 35). It works for cell(5, 35) but returns...

Hi all, I am having some problems in creating some code that will check multiple folders that are listed in cells on a sheet (2 folders per subject), whether the folder exists, count the number of files in each of them and enter the number of files into an offset cell. What is happening is...

Hi, I would like to list all files in a specified folder. The files are placed in the following folder: "\\nodc01\ssa\Utstyr\Dokumenter\" & Me.Internnr" so that it will show different file content depending on what's selected/opened. I have inserted a list and added this code (found here...

How can I get the intellisense to show up when working with the FileSystemObject? I went to tools->References and checked the box to include "Microsoft Scripting Runtime". I only need to include it in the references correct? I created a FSO and then tried doing FSO. and no methods or...

Hello, I'm working on a project that requires me working with files and directories. I haven't had any issues yet with setting up user forms, letting users set file paths to folders or even selecting and importing files, etc... but I'm not sure how to grab all the files in a particular folder...

Hi all. I've created a couple of search folders for Outlook 2010, but they always appear under "Search Folders" which is minimised by default and in a less-than-useful position on my folder list. However, it won't let me drag my custom search folders anywhere else. Am I missing something? Does...

I am changing the name of an EXCEL 2007 workbook ('A.xls' to 'AB.xls') and then changing its location to another folder. I then am creating another workbook with the original name ('A.xls) and placing it in the original folder. Very simple and routine. I have a desktop shortcut pointed to the...

Hi I am hoping someone can please help me. I would like to select a Main Folder and the Macro to then list all SubFolders and Files (within the SubFolders), including the date last modified. Please help. Thanks in advance MarkAn

Hello, I have the following code: Sub Merge2MultiSheets() Dim wbDst As Workbook Dim wbSrc As Workbook Dim wsSrc As Worksheet Dim MyPath As String Dim strFilename As String Dim LastRow As Long Dim wsht As Worksheet Dim i As Integer Application.DisplayAlerts = False...

(Using Excel 2010 & Windows 7) Need to link the separate name of each of four sales reps that are in a drop down menu in Excel 2010 to their individual folders on a Data (E:) shared drive (The Sales Rep's individual folders contain the counties assigned to each of them and they need to have...

I have done numerous searches and attempted different code myself I can't seem to get it to work though and I am hoping someone can help me out. What I want is that when the code is executed it creates a folder for every value in column A and doesn't make repeats. Then Once this folder is...