Extract cell data from multiple files in one folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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