subfolder

Hi, Do you know how to create a new word doc under the subfolder in NewR folder? This is what I have so far. I was able to create a subfolder under NewR folder, but is currently trying to create a word doc in the subfolder. Any help will be appreciated. thanks Option Explicit Private Sub...

Apologies if this is a considered a duplicate post. This macro lists first and second level sub-folders after the selected folder "folderspec", with the condition that any of the subfolders' name contains the string "OK" (sub-folder with this string can be at any level). The output is divided...

With this macro, sub-folders are listed for first and second levels (based on selected folder). The output is divided into separate columns in this example. I now want it to list folders only if any of the sub-folders contain the string "OK". The sub-folder with this string can be at any level...

hello experts! I need your expert advise. I have a folder named Reports and inside this folder, it has multiple subfolders. I am currently doing a macro and my goal is to transfer a specific excel file (with filename "Gross Contribution Report") found inside a subfolder (example Japan) into...

Hello All I am hoping someone can help on this please One of our members kindly gave me this code which works great The only issue is I want to ignore any folders that have "Closed" as the name in any folder but I don't know how to change the code [Public Sub ScanSubfolders() Dim FileSystem...

Good afternnon Mr Excel's forum, I am trying to #1 Open the last email received containing a specific reference in the subject #2 Save it in a specific folder in windows (let's say my documents) #3 Store it in a subfolder in outlook( which is a shared mailbox, different from the defaultforlder...

I am trying to list all the files within a specific directory and it's subdirectories. The following code is working for that. However, I want to only get .png & .pdf files listed. I also want to skip specific folders, either that contains a word or is listed in specific cells. Sub...

Hi guys I have the below code, but I am getting a mismatch error on line 11. Any ideas? I'm a newbie to all this so it's got me stumped! Sub GetLatestFiles() Dim strDir As String, fs As Object, startFolder As String, subfolder As Object, increment As Integer, latest As Integer, latestFolder...

Hello all, First off I want to thank you for taking the time to read my post. Second off, if someone else has posted about this and come up with a solution, could you kindly send me a link to that post. So before I start posting code I want to ask if what I want to do is possible. What I would...

Hi, I got the following code from SpreadsheetGuru and it is a basic loop for all files within a folder (seems he encourages us to ask questions off it - if I'm wrong for whatever reason please excuse the post). Any idea how to modify it to go a level down in folders? Specifically, I have the...

Hi all, I've been trying to work off this older post (sorry if this is not the correct way to reference other posts) http://www.mrexcel.com/forum/excel-questions/525842-creating-folders-subfolders-using-macro.html but my VBA vocabulary is pretty limited to what i could reverse learn from...

Happy Holiday Everyone! I need a little help. I've been playing with this vba code for outlook and it is amazing! Hoping to add a little more code to fix my needs completely. Would like to be able to save the file attachments to a subfolder that is created from the "subject line" of the...

Afternoon, I have a piece of code that I found here: List Folders & Subfolders From Directory That looks in a folder and lists all the subfolders within. I managed to bastardise it to copy the files and folders to an archive folder. However all does not seem to be well with it. It has the...

Hi all Please, tell me that this is possible :) I have folder with plenty of subfolders, each of them contains .xlsm files Each of this file have list named for example "location" In this list, i have data, that i would like to have in one Excel file. The more described situation in that...

I have the following code that hyperlinks the file to a cell in excel when you type in the filename. I need to alter this code and not sure how. I need for the code that when you type in file name it also finds the filename in subfolders also. Right now it only does the top level folder, i need...

I am trying to list all based based on the last accessed date ans show file name, date created, modified, and accessed. As well as give a file count. I have gotten the code to work for a specific folder, but cannot figure out how to modify it to list the files in any subfolders. The code I...

Good afternoon all. I have this genral code which is run from OL XP and it saves attachments to a folder. What I need to know is how do I refer to subfolders of the Inbox? Specifically this line Set fld2SaveAtt = ns.GetDefaultFolder(olFolderInbox):confused: ( I have done a bit of...

Hi, I'm trying to get a macro to do several step to Each file within subfolders. i.e. i select a folder path (C:\Test\) the macro will then open each file in there and save to a different location (C:\Final\) but i can seem to get it to loop through more than one subfolder. Excel...