Copy data from a different workbook

[paulmezick]

I am trying to create a macro, contained in a button, that will open up a separate workbook (book7.xls), copy a range of cells, and paste them in the workbook with the macro.

I thought this would be fairly simple as it is no problem for me to copy data from a separate worksheet, but I am running into a problem while trying to select a range in a different workbook. Below is the code that I am running into the error with:

Please Login or Register  to view this content.

I get the error "Select method of Range class failed"

However, what is bizarre is that when I try to model the code generated by the macro recorder, it is the same EXACT code;except that it works. Below is the macro recorder code to copy/paste special values from one book to another. If I model my code from the macro recorder and place it in a button, it does not work. Does anybody know how to open a separate book and select a range without getting the error I have above?

Please Login or Register  to view this content.

[paulmezick]

Edit: I figured out that I needed to declare each workbook as a Worksheet and use the object to select a range.

However, I am still confused as to why simply copying/pasting the macro recorder code results in an error. Anyone have an answer to that?