combine multiple workbooks/sheets into 1

[scorpweb]

Hi All,

trying to figure out how to do the following:

i want a "compliation" file that i can click a button and it will submit all entries (from worksheet 1-7) of 10 different spreadsheets (1.xls) each book has password of "password" and combine this info into a master spreadsheet (master.xls)

is this even possible? if so can somone point me to somewhere that can help i have been searching but can't find anything relevant to what i need. any help would be great.

 

[VoG]

These may help you

http://msdn.microsoft.com/en-us/library/cc793964.aspx

http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[scorpweb]

thanks VOG will give it a look