Copy a cell value from personal.xls

[AidanEnos]

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

[john_murphy]

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

[email protected]

John Murphy
Galway