closed files

Hi, ultimately want to create VBA that will allow the end user to select closed Excel documents using Windows explorer, then copying the tabs to a new workbook.

Hi Folks, It's times like this that I wish I studied programming! Looking for code that will evaluate every file in a directory, pull in the value from two specific cells from each file, and place them sequentially in one workbook - one pair of values per row. I used this code to get values...

I am trying to use Harlan Grove's pull function but I can't get it working despite spending a good deal of time doing the research and playing with various options. That leaves me in 1 of 2 places, 1) I'm not using the latest code, or 2) there is something so obvious that my brain has stopped...

Hello, I'm looking to reference an array in a closed workbook as a part of an index match function. I've got the following hard coded function to work: =INDEX('C:\Users\owner\Documents\1.1.1\[CAP 1.1.1-REPLAN.xlsx]CAP'!$1:$1048576,MATCH(E5,'C:\Users\owner\Documents\1.1.1\[CAP...

Normally when we record a macro in excel, it is applicable on one file. As such, we are required to run the macro in every file in the folder separately, which is very time consuming. I have 250 to 300 files in a folder with similar structure and I am required to perform various operations on...

Hi, I am trying to return a range of values ("F23:K23") from each sheet named ("Test") from each file in a folder named ("January 2011"), to a seperate worksheet. Each time the refresh button is pressed the code should look at each file in the specified folder and return the range on each...