Macro Help With Copying Multiple Columns to New Workbook

I have done this before in 2007 but having problems getting it to work in 2010. I am doing some work that involves copyinging multiple columns. For example i would like to take copy A1:1000 from one workbook to, say, D1:D1000 in a new workbook.

Here is an example of the macro I used when I still had 2007:

Please Login or Register  to view this content.

For some reason it wont open the new workbook like it did before to paste the information from the original workbook.

Any help would be appreciated. Thanks!