Reference different workbook

[chris100]

Hi all,

Sure this is a relatively simple one but i'm having trouble (i blame
the night befores alcohol intake).
I want to send this info to a workbook called "sales" in the c:\ drive
into a sheet called "sales". What is the correct way to reference this
in the code below:-

Sheets("INVOICE").Select

Dim lrw As Long, cl As Long

lrw = Sheets("sales").Cells(Rows.Count, "A").End(xlUp).Offset(1,
0).Row

Sheets("sales").Cells(lrw, 1) = Sheets("invoice").Range("F3")
Sheets("Sales").Cells(lrw, 2) = Sheets("invoice").Range("M5")

Thanks in advance as usual.

Chris

 

[Guest]

see a possible answer to your second posting of this question.

 

[chris100]

thanks tom, i had a problem logging on when i posted.