folders

Hi, I have the below macro. It asks to select a folder and makes a list of folders. I need a changes. I need to make a list folders in the selected folder. Help me. Sub GetFileList()Dim folderPath As String, nextFile As String, i As Long With...

This might be kind of difficult for me to explain (it would be easier to show), so please bear with me. I am creating an audit sheet (workbook) for each employee that draws data from several other Excel workbooks. I have everything arranged in a folder and sub folders. For example, 2018 has its...

I am new and was not able to find something specific. We have an external drive, this drive has folders, in those folders there are more folders, in the folders are videos of various formats. Im looking to list the top level folder name and below that list the names of the files. In excel...

Hello, I have a current MACRO I use when ran prompts the user to select a location to save all folders. Once the user selects a location and hits "Ok" the MACRO creates a new folder using a list in excel (E26:E75) that the user can modify so they don't have to manually create folders and rename...

Hi! Thank you for your replies. Is it possible to programmatically zip ALL the folders in a directory into INDIVIDUAL zipped folders in that SAME directory? For example, say I had the following directory: C:\Users\john\target and there were FILES and FOLDERS in that directory and I only wanted...

When I click on File, Open, and then Recent in Excel 2016 (version 1807) I have links for both Workbooks and Folders. Conversely I've run across Excel 2016 users that are missing the Folders link, and can only choose recent workbooks. I seem to recall that this initially missing from Excel 2016...

Hi Guys, I have been looking online but cant find anything matching my requirement and wanted to ask the question to see if it is possible. The requirement I have is I have a folder with 100's of individual sub folders, I need to place a blank word template that I have saved on the drive into...

I have used a macro to create a bunch of folders and filed sub folders into main ones. I now wish to create an excel spread sheet titles as names in a column and file them within each sub folder. Image as an example using simple formulas I can make column A = File path and Column B = File...

Hi all, I've searched around and am mostly coming up with code to check for actual URLs that point to http sites. I'm looking for one that can run through my sheet of links that direct to other files and folders within my network, ensure they point to a link that can be opened, and return the...

I have several folders. for eac h, I need to list the memory used, the number of folders and numbers of files under each folder with its name) Just as if you had click proerties on each one. VBA for this? I have about 100 folders (not including subfolders) in each of 5 directories....... thanks.

Hi, I need a code that will paste a list of file paths contained within a folder and all its sub folders and all the sub folders withing those sub folders and so on. I have currently got a code that will ask you to pick a file and will then list the file paths in that folder whilst ignoring sub...

Good day All, Hope all is well. I humbly ask for your assistance, and help me have a macro that will list all the filenames (including their creation date, modification date, hyperlink file path) in all the folders and sub-folders of the below directory: O:\ITSC\RSG I would greatly...

Hello, I've been trying to figure out this task most of today, and I'd love to get some feedback/advice. I have 2 columns of information. Column B has the names of several PDF documents and Column C has descriptions of what each of those PDFs are. Currently, all the PDF files are in one...

Hi, Very new to VBA and currently using to the below code to create a folder and pdf from one worksheet within excel. Sub APOrderForm() Dim myDir As String, myDirSub As String, mySht As String, c As Range myDir = "P:" & ActiveSheet.Range("C16").Value mySht = Range("C16").Value On Error...

Hello all, I am new to VBA coding. I had taken a programming course almost 6 years ago and never touched it since but I would like to start learning slowly to automate a lot of my excel stuff. I have 18 folders at a particular location in my drive. Out of the 18 files, 12 are files with names...

Hi All, I need a script that will use the "ThisWorkbook.Path" and looks for a folder called "sFiles" in the workbook path and if not found, then create it and inside it, create other folders matching the names for all items in TextBox2. TextBox2 is populated by TextBox1 Thanks in advance Kelly

Hello, I have a macro set up that is designed to copy all of the data in a particular tab on a sheet, and transfer it to a new sheet, and then to save that sheet. I'm wondering something though, since all of the folders that I save data sheets in have a certain naming convention to them, is...

Hello, I have the following workbook macro that lists all files/folder names from a directory. I would like to exclude all folders from being listed (the only folders that would be in this directory would be .zip folders). Ideally I would not want any folders to be listed in the workbook...

As the title of this post suggests, I'm trying to use VBA to write some data into another workbook. I did some looking on the internet and this is what I've found. This code doesn't crash, but it sure as heck isn't writing the data to anyplace where I'm expecting it! Not sure what bearing this...

Hoping someone can help. I can find code for various parts of what I want to do but I can't find everything. I have a summary sheet where column A has a list of names. Column C has a list of sheet names. Those sheet names form the rest of the workbook I want to split the workbook and save the...