directory

Here's what I need to do: I have a workbook (destination) that needs to open the latest version of a file (source) in a specified directory and pull certain fields from a lead sheet and place them in the destination workbook. - the directory will only store versions the source file - the source...

Hello everyone, Pls Help, I have a folder directory (Name: "Company 2009") containing excel files:- We want to find Name of File Containing Text "No Ceiling" and show a list of File Names having this content. Thanking You

I have some code which is opening up a file directory from Excel but I have a couple of issues. Primarily it debugs when the file is being set (Bolded below). I get a type mismatch and I cant figure it out why! Further to that, and this isnt important really, but is there a way of limiting...

Hi All I have a code that loads files from a specific directory. All files at named based on a simple dateformat i.e 01012018 or 19122018. My issues is that when the files are loaded into the listbox, they are not sortet. Sorting the folder does not solve my problem. All i really want is for...

There's a CSV file at the path: C:\Users\Me\Documents\data_files\quotes.csv I have a different file (mainfile.xlsm) open in which I want code that will fetch the date the quotes.csv file in the directory above was last modified, and paste it into cell A1. Anyone help? Thank you!

Hi, I need some help writing VBA code where you input a search term and all files within a directory and all its subfolders which contain that string are found. The code should then delete all rows in all files that contain the specified string. File format would be csv,

Hi all, I have a list of SharePoint file URLs and I need you help with a formula to extract part of the URL up to the 2nd sub directory or sub-site e.g. http://company.sharepoint.com/teamsite/Subdirectory1/ http://company.sharepoint.com/teamsite/Subdirectory1/folderA/folder1/...

So what I'm wanting to to may be rather simple, but I'm having a difficult time finding the answer. I have a file of tracking numbers that is client specific. What I want to do is create a macro where the user will specify the client name and a file directory, and the macro uses this...

I know I can change the SaveAs path using application.GetSaveAsFilename initialfilename:="%userprofile%\Downloads" but this results in the user being presented with the SaveAs dialog. I want to change the SaveaS directory they are shown if/when they issue their own SaveAs (or Save) request...

Hello again guys! I'm either overthinking this, or not fully grasping the concept. I'm trying to save a file as PDF (with a file name from a cell value) to the same directory, but for whatever reason, it keeps saving the PDF's to one directory above. s = Range("B2").Value...

Hello, I am creating a worksheet that I want to export as a pdf when I am finished. I want it to go into the current directory, but it is dropping into "My Documents" in one way and one directory up in the second version. I could get around the thing in the second version, but it is also adding...

Is there vba code that can check the current file directory and force a user to save as to a new directory and file name on opening? I have not wanted to set up my file as a template, but I don't want users making changes to the master file and saving it.

If i have my directory listed in a cell say E2 on a worksheet within a workbook, how can i get excel to open it as a comma delimited text file? I also have a list of about 10 and want it to loop through all 10 names, opening all the text files. Anyone help?

Hi guys, I stuck with a problem where I hope you can help. Situation: I added a macro that allows me to import excel worksheets from other workbooks. The imported sheets have formulas in cells "B6:CX49" still referencing to another sheet in the workbook from where I have imported the sheets...

Hi I have a simple excel database which I use filters to maintain data about files. I want to have a way of choosing a file or a directory and adding a new row(s) with the file name, directory name, full path , creator, hyperlink and date. I will then add all the other details So I can do...

Good Day! I have a workbook that I have put in the below VBA. In theory, it is a simple and straight forward module..open workbook, copy from it, paste into another workbook, close workbook... I am trying to make this as end-user friendly as possible, as not all of my users are not...

I want to loop through a directory of excel files and insert pictures from another directory that goes down the line of excel files and inserts the pictures one after the other in the picture directory. Below is the code to help show what I mean. I want the insert picture to be on the...

Hi All, I've got a couple of hundred spreadsheets that have a default worksheet listing dates. Is there a vba, batch file script that will copy a new version of that worksheet to every spreadsheet in a single directory? The worksheet is named exactly the same "Holidays". thanks in advance

Hello all, My overall goal here is to preform a VLOOKUP of data from an external file (user-defined) but to allow the parameters of the VLOOKUP function to be dynamic as different users have differently formatted directories. Below is what I believe to be the relevant code: Global variable...

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