folder

Hello All, So I feel like this should be relatively, easy but really have been struggling on the syntax. I currently have a functioning Excel macro to create a folder in my Outlook Inbox, but what I really need to do is create it in my .pst file folder structure since our Outlook storage is...

Hi I got this code: Private Sub GemSom_Click() If Dir(ThisWorkbook.Path & "" & Range("b6").Value & " " & Date, vbDirectory) = "" Then MkDir ThisWorkbook.Path & "" & Range("b6").Value & " " & Date End If 'Dim Path As String 'Dim FileName As String 'FileName = Range("b6").Value & " " & Date...

Excelisfun has a video on this topic. https://www.youtube.com/watch?v=0NX-GctfZuU I performed the steps and had my query set up. Then I added next month's sales file to the import folder and hit data refresh. The query only pulled in 1 of the files (oddly enough, the most recently added)...

Hello! hope you're doing well! i need assistance with the following task..i have a rule sending specific emails to a folder in outlook...i found the following code on youtube and modified it to allow me to enter the email folder name in a specific cell. my problem is due to my limited VB coding...

Hi All, I'm working with this code in producing a common file folder in the current directory. Sub MakeMyFolders() MkDir ThisWorkbook.path & "\mmyy" End Sub I'd like to use the Format(Now(), "mm-yy") to produce the current month and year for the file folder. Can someone please help...

Within the Visual Basic Editor on the left side there is the Microsoft Excel Objects folder tree that contains all of the sheets in the workbook. The workbook that I am working in has many sheets and it "pushes down" the Modules folder and Class Modules folder, forcing me to scroll down to see...

I have a file that I am using as a template for divisions to retrieve productivity report. So when user opens (Read only), he then logs in and their particular division(s) data will open. Since it is read only. I t prevents people from saving over the file so all can use as a template and I...

I'm trying to find and figure out the vba code needed to copy selected cells from all workbooks in a folder and paste the values only into the new "master summary" workbook, incrementing each pasted value to the next available line. I've tried several different codes but still can't seem to get...

Right now I've set up the query to pull form a folder. However, I'd like to move the files to a different folder/location. So I went ahead and did that. Then I went into query editor and double clicked on "Source" under applied steps. I changed it to the new folder and hit "OK." I get this...

I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...

Hi all, I hope you could help me with this. I have 3 closed WB in a folder, in the following terms: A) WB "A". With one sheet called "A" B) WB "B". With one sheet called "B" C) WB "C". With one sheet called "C" I have another workbook, called "SUMMARY", in the same folder. What I need is to...

Hello I'm very new to VBA , at the moment I'm using the following code to Copy files from one folder to another based on a list in Excel, and it work perfect what I'm looking for is instead of search in on folder is also search sub-folder <tbody> <code class="vb keyword"...

Hi All, I'm after a program that will loop through all folders and files in a directory regardless of what file type they are that are less than a specific size lets say 15GB and move them to a folder that it creates on the desktop called the less than 15gb and the date and then go through the...

Hi all: I want macro to check all file name in folder, if file name similar (different one or two charactor) will create new folder "OLD" then remove file with number smaller to folder "OLD" Example: Folder have: G03144-99201001-01201001-201906-BI-M-01.xlsx...

Hi all, I wonder if someone could help. I have a table in Sheet “Final Filtered” range A1:S510. I like to create a new workbook and filter by manager which are in column G. Sheet “Names” rows 2 to 21 has all the unique managers names I need. i also like to save the new workbook in the same...

Hi and thanks in advance! Imagine I have a Path and a String: wPath = "C:\Users\MrExcel\Desktop\Works" wName= "France" I would like to prompt the user to select any Excel file within the Path = wPath containing the Name = wName I know How to prompt the user to select within the Folder wPath...

Hi All, Long time lurker but first time poster. I have a scenario where I'd like to use a list in Excel to search for and copy the corresponding files to another folder. I believe I have most of the code written and it seems to work fine except for two small issues. One issue is that I need to...

Hi Everyone, I need help....... I am trying to create a macro which will count the number of .pdf files within a specified folder based on a a date range. The dates are set in cells b5 and b6 (start date and end date) and the file location is in a cell named "Folder" I have been watching VBA...

I want to create a search function inside excel where by the user can type in some key words, click a search button and excel will open a specific folder location and search those keys words in the folder. For example if the user searched "help sheet", it would open a set folder path and search...

Hello. I am trying to import a webpage and its tables into excel I use the data tab, then from web, and import the webpage When I do this, the web view on the pop-up displays the webpage perfectly. Note - It does have the "table highlighting is disabled because...." On this webpage, there...