Pulling data from several workbooks to single Master workbook

**stin25** · 06-16-2009, 11:30 AM

I know there are about a thousand of these floating around on here but I cannot seem to find one that helps. Here is what I have so far

Please Login or Register  to view this content.

This is the error that I get when I try to run it

Run-time error '1004':
Application-defined or object defined error

I am trying to pull data from "Copy Recap" B4:B44 and put it in "Book 1" B4:B44 of the other workbook. I have no idea if the names are right in that code or not, it is just something that I found on here from February of last year.

thanks for the help

**ConneXionLost** · 06-16-2009, 11:40 AM

Hi stin25,

You might get a better response if you posted this in the "Excel" Programming forum instead of the "Access" forum. Just ask one of the mods to move your post.

Cheers,

**broro183** · 06-16-2009, 01:23 PM

hi Stin25,

I agree with ConneXionLost's suggestion - here's a link to the Moderators:
http://www.excelforum.com/showgroups.php

I have made some changes (esp on the second dest address & including a sheet reference*) so hopefully the below will work for you...
(if not, please advise which line causes an error)
* there can only be 1 active sheet in an Excel instance & it is the one that appears when you press [alt + F11] while in the VBE.

Please Login or Register  to view this content.

hth
Rob

Pulling data from several workbooks to single Master workbook

LinkBack

Thread Tools

Rate This Thread

Display

Pulling data from several workbooks to single Master workbook

Re: Pulling data from several workbooks to single Master workbook

Re: Pulling data from several workbooks to single Master workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions