I am trying to create VB code that takes data from one workbook and add
info to a master workbook (database).

The filenames will all have the same prefix followed by a series o
numbers.

Here is the code that I am using to grab the data from one workbook an
insert it into the database.

Range("L2").Value = Range("'[oef.xls]Sheet1'!C12").Value

This code assumes that the name of the file I am inserting will alway
be oef.xls, however I will be taking data from files called
oef-1111.xls
oef-2222.xls
oef-3333.xls, etc...

I would like the code to be able to pull from these files without m
having to rename the sheets from oef-1111.xls to oef.xls.

Thanks for your input

--
bg1846
-----------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...nfo&userid=887
View this thread: http://www.excelforum.com/showthread.php?threadid=54991