folders

Hi all, I am using a macro to create a folder. This is working perfectly. However, when I try to save something into that newly created file, I get a popup saying "The file could not be accessed. Try one of the following..." This is the macro used to create the new folder Sub...

I want to retrieve some cell values from another workbook which each time has a different name. The variable name of the workbook is placed in cell c3 on sheet1. It needs to search for the variable workbook in two different folders and get the data from cell D5. I tried to do with Vlookup, but...

Hi, I am stuck. I want to create a folder named from a cell, then another directory from a cell then a report filename from cell + report for example 123456report. My below VBA worked with one sub directory but not two.....the below is what I did to attempt this but it is not working....it...

Hi All, I am working on some automation and need your help in vba code to get excel file names from respective folders......for example ..I have 10 different folders and need the file names those were inside the folder to excel cell starting from A1, A2, A3...so on... if I get the complete...

Hello All, I would like to know why do we create objects for folders in vba. What does object do? Thank you in Advance! Your response is greatly appreciated!

Hi all I am quite new to VBA and have found a number of the posts on this board really helpful! I have come across a query I haven't been able to find an answer for though - I have 60 folders, each assigned to a different client, and within each of these is the same set of subfolders. I am...

I want to make a hyperlink for these cells going to folders of the same name. I would like to automate this process as I have over 250 individual cells to link to folders accordingly. Is this a possibility? 201712001 <= i.e. to folder D:/2017/12/201712001 201712002 <= i.e. to folder...

Hello, Whenever I click the "double down arrow" next to Content in my query that I just created from a folder that contains CSV files, downloaded from ExcelisFun PowerQuery04, I am getting a new screen titled "Combine Files"; Combine Files screen is asking me for Example File, File origin...

Hi all, I am in the stage of tidy up all my UDF and and Sub Procedure I wrote since several years ago. As of now those excel files scatter in many folders and sub folders. What I am looking for now is excel VBA with ability to loop through folder and all its sub folders and create a list of "...

Hi, Please help me in getting code of 7zip of all folders in a given range I have the code of zip but the size of zip goes beyond the limit most of the time hence looking out for 7zip of folders in a given path Please assist

Hi I was wondering if I can get some help, we have received a load of data in folders based on cases, we know from each case via a lookup which case belongs to which individual. <colgroup><col><col></colgroup><tbody> Existing Folder New Folder h:\ESCC\OB\KYB\3923 H:\ESCC\Donna Waddington...

Hi there, I'm trying to exclude specific file types when doing a count within folders in a specific directory. The code below works when the file is NAMED, but only when. I need some guidance on how wildcards would be used in a situation like this. In addition, I would GREATLY appreciate...

Hello all... I am creating a database spreadsheet for files I have on my hard drive. I found the script I want, and it works, but there are 2 functions I would like to have it do to smooth the process. What this code does is pulls all the files in 1 folder & gives me the data from the...

Hi, I have been creating folders in Outlook using a simple macro that creates folders from the first column of an Excel sheet under the folder currently selected. That macro is based in Outlook. We are at the beginning of a new fiscal year and I would really like to create the whole tree at...

Hi all, Thank you in advance as always for any help. I have lots of printing of multiple PDF files to print and I wonder if someone can help me if its possible to do it with VBA? I have one single file path - within that file path are a set of folders in each of those folders are files, all...

I want Excel to search all folders located in C:\Users\Daniel\Desktop and find a folder called "X" (value pulled from A1) If such folder exists, and contains images, import the first image it finds (earliest Created date) How do I do that?

Hello guys,I have this code which serves to copy the information of the mails of the folders and subfolders that I have selected.But what I want is that in line 1 only the name of the second folder comes out. What happens is that I have the main folder that is "Advisors" and inside that folder...

Is there a VBA code that would allow me to select folders in a directory and copy to another directory without copying over the subfolders and the files? Thanks :)

Hello everyone, I am very new to VBA (I have used it for some minor tasks), but at the moment I am faced with a challenge and I am not sure how to approach it. The task is as follows: 1). I have two folders (two different locations) which contain a number of .csv files (200+) 2). What I need...

I have code to list the content of one directory's files but need to list the files in multiple directories that are listed in row one of my spreadsheet (ex: m1, m2, m3) where m1, m2, m3 are folders. I cannot get the dir function to use a variable in my loop to pull the text of m1, m2, m3 in...