subfolder

Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...

I have a main folder on my desktop, lets call it 'C:\Users\Desktop\Update'. Within that folder I have 3 additional folder lets call them 'FY21', 'FY22' and 'FY23'. Within each of those subfolders there are 5 XLSX files. I have created a code for each file based on the subfolder they are in. I am...

Hi, I've looked around here for the answer but could find any like mine and my go-to IT Mgr. no longer works here, so I'm having to learn all of this on my own. The VBA code I have saves the current .xlsm as .xlsx as it's supposed to. It is a checklist and I'm wanting to save the workbook in a...

Hi There, I currently have this code to break links on excel files in a selected directory. I am currently having issues updating this to also look at excels in subfolders. If someone could assist me with this you will be a lifesaver! Sub Delete_Bad_Links() 'Sub LoopAllExcelFilesInFolder()...

I wrote some codes in excel to extract information from a shared Outlook mailbox. But the codes sometime work sometimes don't although I didn't change anything. The error happen in line "Set InvFolder...". It can't find the subfolder. But it works sometimes. So weird Can someone help me? Thanks...

ello any help or direction to recourses or YouTube will be appreciated to help me in resolving below I need to aggregate multiple xls files with specific name from multiple folders and subfolder into one file. I receive multiple reports every day that are saved with in folder with Date in the...

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

Hello, I've got some code that is supposed to expand some folders in Outlook. It works fine for the first level folders, but won't expand the subfolders (in this case the xx Progressions folder). The code doesn't bug out: the subfolder simply does not expand. Could anybody tell me what I've...

I found this great article (http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html) and it is exactly what I needed. I’ve tweaked it to reflect my circumstances, my issue is, I’m trying to pull certain cell Information rather than all the information about the file itself...

I had a code which work very well for 1 location (path) Possible to open and run 2 location? Sub GetFolder() Range("A:L").ClearContents Range("A1").Value = "Name" Range("B1").Value = "ParentFolder" Range("A1").Select Dim strPath As String strPath = "K:\VIEWING" 'strPath(0) =...

Hi Everyone, Below i have a code to move all the mails to sub-folder but i am facing an error in highlighted line could any one suggest me why i am facing this error???? Option Explicit Public Sub Move_Items() Dim Inbox As Outlook.MAPIFolder Dim SubFolder As Outlook.MAPIFolder...

Hello my friends, I have a file mainlist.xlsx in my folder C:\Database Inside this mainlist.xlsx file, there is list of cars. in A column car brandname, B column: model name, C column model year, D column motor volume and E column price In this manner, I want to have VBA to create folder with a...

i want to use vba to count all the lines in all the files in all the subfolder of a directory and display them in a cell. how do i do that? i found a code working for counting the lines in a single file. but i dont know how to construct the loop to apply this to all the files in all the...

I am trying to count the amount of emails, in real time, in a subfolder in Outlook 2013 and automatically export the data to excel. I don't mind opening the excel document and refreshing the data daily, if needed. The subfolder is called "disks" - it is in a group mailbox subfolder. Any ideas?

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 :)

I am trying to use the following code to open a pdf file from a folder, but I keep getting the "File not found" error. Shell "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Adobe Acrobat DC.exe " & FullPath & """, vbMinimizedFocus" Is there something I am missing? Below if the whole...

I'm using this to loop through a folder and list all found files; Sub GetFolder() Range("A:L").ClearContents Range("A1").Value = "Name" Range("B1").Value = "ParentFolder" Range("C1").Value = "Size (KB)" Range("D1").Value = "DateLastModified" Range("E1").Value = "DateCreated"...

Hi All, As per the title, I am having an issue with iterating through folders and files where the path exceeds the charater limits. Below is my code: Sub test() Dim FileSystem As Object Dim HostFolder As String HostFolder = Sheet1.Range("F16").Value If HostFolder = "" Then MsgBox "No...

Hi everyone, I am new to this forum even though I have been using it for years. My turn to ask for your help as I couldn't find a solution to my problem so far. Here is my issue: I have several files with a given name in a same folder, let's say drive D: Ex: D:\AAAA.xls D:\BBBB.xls D:\CCCC.xls...