Hey again,

I have another newbie question for you all.

Ok, so there is an excel spreadsheet that one part of my office save
daily with personal information such as company name, address, taxes
proceeds and whatnot. Lets say the name of the file is always:

"recon 1 18 04" (the current date at the end)

There are workbooks that I use daily that are different for ever
company that we work with. So I usually have to open my workbook, dum
the recon spreadsheet into its own sheet in my workbook, take th
information pertaining to the company that im currently working on an
use that info to populate fields in my workbook.

I would like to add a button to my toolbar that would grab the reco
file from where it is always saved (lets just say C:/reports/ ..) dum
the information into my workbook as its own sheet and take the inf
with the companys name that im working on and populate the field
corresponding to that information.

I hope I was descriptive enough.

Thanks

--
Message posted from http://www.ExcelForum.com