Results 1 to 2 of 2

Thread: Copy a cell value from personal.xls

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Location
    Toronto, Ontario, Canada
    Posts
    8

    Post

    Okay,

    I have a spread sheet that has data copied in for 5 days, then there is a graph created with that data. When the data is copied there is sometimes an anomoly that causes the date to go from 11/10/99 to 11/11/03. Why this happens, I don't care - I've been told it's an Excel bug in copying from text files.

    What I want to do is take the Monday's date (c68) and the Friday's date (s68) and tell them to be equal to a2 and b2 on personal.xls. (I have created input box requests to get the proper date in those 2 cells)

    I have tried:

    Range("s68").Select
    ActiveCell.FormulaR1C1 = "=[personal.xls]sheet1!($b$2)"

    But that gives me a 1004 Application-defined or runtime-defined error. I have tried it with the personal.xls hidden and unhidden and I get the same result.

    I get the same error with Activecell.value = so I'm not sure what is the best way to get this to copy properly.

    Thanks!

    AidanEnos

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Galway, Ireland
    Posts
    316

    Post

    send me a copy of the xl spreadsheet and I will fix for you

    johnm@meritsolutions.ie

    John Murphy
    Galway

Posting Permissions

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



Click Here to Expand Forum to Full Width