directory

Hi all, I'm using application.getopenfilename to select multiple files from a directory. However, the directory holds 1000+ files and I only need the ones with the string "valuations" in it. So for example I need the files 20180108-Valuations, 20180518-Valuations etcetera. To make life easier I...

I have a spreadsheet "Contracts.xls" and I would like to be able to open PDFs via a hyperlinked cell on each row. The PDFs are stored in the same directory as the spreadsheet. For example, for contract 0001 I have a pdf in the same directory named 0001.pdf. The path to the directory will change...

Hi there, First of everything thanks for spending time to read my post. I'm a amateur to VBA, but I need something complex to help in my work. Scenario: 1) Cells A5 contain "Instruction A" , I would like to have VBA to able to read the cell and create hyperlink to my directory example...

Hi there, It's more a general question than purely related to the vlookup function. I am currently able to pull cell data into a worksheet from other workbooks. When I specify the directory in full, the data pulls through: e.g. C:\User\Miscellaneous\Example - 1.xls However, is it possible to...

I received great help from Fluffy yesterday. I've been working all morning and just can't figure this out, its a mess. I am a beginner and putting in time to learn but running out of time. It doesn't help that I am not the sharpest tool in the shed. I appreciate any and all help. I want to...

I have been working in Excel for a few weeks now building a massive website style book. I have ~29 Employees I'm working with, and I'm trying to make an easy way to add/remove employees and data entry throughout the entire sheet. I'm a little lost however, as it's not really a math equation, or...

I am trying to come up with VBA that finds a workbook in directory based on a value in A14 that is part of book name. Let's say A14 = 123456, there is a workbook named 123456 abc.xlsx in directory ( I have named this book ws1) and then copy a few values from that book and paste it in the current...

Hi Guys, Need help with a VBA code to save to directory if found. Saving bit I know how to do it's just finding the sub-folder in a directory path is the bit im having trouble with. Example: G:\Test\New\Folder In this directory you will have folders 1 Jan 2 Feb 3 Mar 4 Apr 5 May 6 Jun (etc)...

Hi to every one, I am having a problem while hyperlinking bunch of files. I have a macro which takes the name of files from a directory and then copy in Excel Column and Hyperlink them. But now I want to macro to check file names from Excel file Columns, search in the Directory and...

Good afternoon. I'm hoping you all can help me (again). I have a directory that is a repository for forms created in excel. All the forms have the same format. Re repository may contain hundreds of forms in various stages of completion. A form is "complete" when all the required reviewers...

I want to be able to insert the directory of a workbook in a cell and then be able to reference that workbook to do an index search of the workbook. IE; Cell A1; C:.....Desktop/MyExcel.xlsx Let's say cell B1 has a value of 42.... I want cell B2 to index\match search Column A of MyExcel.xlsx to...

Hi! I have a problem with self-written *.exe program which is working with current directory. When i run it manually, it does fine. but if i try to do it using VBA - the pass to current directory changes (like excel copies it to some directory and run). can someone explain me how excel runs...

I get an error running a SaveAs routine where the message says it cannot access the file 'C:\Users\<user>\Documents\Root\Reports\057B2600' I don't understand where the 057B2600 number is coming from at the end of the path name. Reports directory is where the file is to be saved as in. The...

Hi there, I am looking for a way to paste the directory of a file into a cell of an open workbook. I need the ability to open file explorer and choose the file to copy the directory from. Thanks, D

Hello, I've been reading through the various codes for consolidating data from multiple files in a given directory, but nothing seems to be exactly what I'm trying to do. Here's the situation: I have a master consolidation workbook titled "Master Backlog", in a worksheet called "Backlog". I...

Good Morning, I have been utilzing this macro for some time and trying to change to the best of my ability as years go by and as my main "directoy" tab changes. I know enough about macros to be dangerous and really screw this up! I am creating new tabs from the "T" column in the "Directory"...

Hi guys How would I go about writing a VBA script that would essentially search within a directory and it's subfolders (which will always be "H:\Everyone\SOFTCON PCS") and then open the version of a file (which will always be called "EGBCIS13") that corresponds with the current month (based on...

Hi guys I want to use VBA to source a file and then open it. The directory will always be H:\Everyone\SOFTCON PCS. I then need the VBA to go into the last modified folder within this directory, and then open EGBCIS13.TXT (using Excel) from within this folder. I've no idea where to start. Any...

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