Extract cell data from multiple files in one folder

[smonsmo]

I have multiple randomly named contracts files in a folder(saved as Customer
name, last name,first name). They are placed in this folder based on cell
data for the month the contracted work is scheduled (masterU3). What I would
like to do is extract the dollar total for each job (masterw29) found in
this folder and compile a list by week for the total amount contracted each
week. This way I can better judge the way I schedule the work.

 

[Ron de Bruin]

Hi smonsmo

Start here
http://www.rondebruin.nl/copy3.htm

If there are a few cells you need you can also create links
http://www.rondebruin.nl/summary2.htm

 

[smonsmo]

Hey Ron,

I tried this:


Sub RDB_Merge_Data()
Get_File_Names _
MyPath:="J:\BLACK FOREST HARDWOODS\2007 Contracts\JOBS BY
MONTH\AUGUST", _
Subfolders:=False, _
ExtStr:="*.xl*"

If fnum = 0 Then Exit Sub

Get_Data _
FileNameInA:=True, _
PasteAsValues:=True, _
SourceShName:="", _
SourceShIndex:=1, _
SourceRng:="A1:G1", _
StartCell:=""
End Sub


I get this error:

compile error
sub or function not defined

What did I do wrong?
Thanks for the help

 

[Ron de Bruin]

You must also use the Get_Data macro

Download the Example workbook with the code