Results 1 to 4 of 4

copy values from a worksheet to another workbook. source workbook name unknown

Threaded View

sark666 copy values from a worksheet... 08-12-2009, 06:52 PM
Leith Ross Re: copy values from a... 08-12-2009, 10:11 PM
sark666 Re: copy values from a... 08-12-2009, 11:03 PM
Leith Ross Re: copy values from a... 08-12-2009, 11:05 PM
  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    vancouver, BC
    MS-Off Ver
    Excel 2000-2003
    Posts
    13

    copy values from a worksheet to another workbook. source workbook name unknown

    I need to copy a range of values (actually two ranges). The ranges are of fixed size. Le't say A2:D20 and E2:H20.

    Both workbooks have the exact same layout, and they both have the same named worksheet (in this case it's called Entry). However the actual filename of the source workbook is unknown. I know numerous users have changed the filename of the xls file.

    I want to instruct them to open the old and new workbook, and open a third workbook containing the copy macro, they run the macro and it copies the data.

    How can I reference a known worksheet name but of an unknown workbook name esp when the source and destination share the worksheet name?
    Last edited by sark666; 08-12-2009 at 11:04 PM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1