I am an entry level VB person just starting VB classes.

I am attempting to copy worksheets from a closed, password protected workbook, to the active worbook. I want paste value the data into the same worksheet each time, in the past this data was linked. The link have always slowed down the PC performance and have led to many memory issues.

It appears to be worse now that we have switched to Excel 2007.
...