Pull out numbers and text from 10+ excel files in a folder

**ammarkhan** · 08-22-2012, 12:39 PM

Hello everyone,

I am looking to build a macro that goes through all the excel files (and their tabs) in a folder and pull out numbers which start with 01 or 02 and copy paste it into a new excel sheet.

I want it to go through those sale excel files (and their tabs) and pull out text in a certain font colour and paste that in a new excel sheet.

NOTE: The text and numbers are in text box and not cells.

Could someone kindly point me in the right direction on how I can go about doing this?

Thank you

**xladept** · 08-22-2012, 07:43 PM

Hi ammarkhan,

Could you supply more specific details fr the name of the folder and its path, the source for the textbox if there is one?

It sounds as though you'll need to "run the directory" by succesive calls to Dir() (after the Path has been invoked one time)

and then you'll want to traverse each sheet in the work book - I need more information about the Text Boxes to be more specific.

**ammarkhan** · 08-23-2012, 04:13 AM

The folder sits in my Documents folder and the text box is the standard one that excel uses so unsure what you mean by source.

I hope that answers your question?

**xladept** · 08-23-2012, 01:38 PM

So, the Path is C:\My Documents ??? and the Textboxes are all TextBox1??

**ammarkhan** · 08-24-2012, 06:38 AM

Yes, that is the path. I am still unclear about text box. I have taken an image to explain which text box it is here - http://screencast.com/t/8FWeX27F5lT