+ Reply to Thread
Results 1 to 4 of 4

Copying from Workbook B into Workbook A Run time error

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    16

    Copying from Workbook B into Workbook A Run time error

    Hello,

    I have been playing around with two test spreadsheets trying to understand how I can copy data from Workbook B to Workbook A (Test Unlocker File.xls).

    I have created a basic macro to open Workbook B from Workbook A. Workbook B has all it's sheets protected by a password - this I can get around (just copying in from Workbook A to clipboard to paste into input box in Workbook B)
    But I am having a problem with copying even a single cell of data from Workbook B and pasting it in Workbook A.
    I am currently stuck using Excel 2002 instead of my usual Excel 2003.

    Please Login or Register  to view this content.
    As you can see from my code I am no expert. Any help that anyone can please provide would be greatly appreciated.

    Thanks.
    Last edited by quetzalc0atl; 04-14-2013 at 02:43 AM.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Copying from Workbook B into Workbook A Run time error

    Missing a "(" might be the issue. I haven't thoroughly looked it over for other issues.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-21-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Copying from Workbook B into Workbook A Run time error

    Hey thanks for getting back to me. I'm afraid that was just a typo on my part when entering the code to the forum post.
    Part of me thinks that it could be do with the fact that I am on Excel 2002 but another part of me thinks that I have made some noobish mistake that I can't see with the code.

  4. #4
    Registered User
    Join Date
    12-21-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Copying from Workbook B into Workbook A Run time error

    If it helps I have attached the 2 files that I am working with.

    Thanks again for any help.
    Attached Files Attached Files

+ Reply to Thread

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