Macro to another workbook

[markgoudswaard]

Hello,

I'm trying to write a macro that grabs information from another workbook. How would I write the link to this workbook?

My guess was something like this but it's not right:

Workbook("workbookname").Worksheets("sheetname").Range("K3:AC79")

Thanks in advance for any answers

 

[VoG]

Try like this

Workbooks("workbookname.xls").Worksheets("sheetname").Range("K3:AC79").Copy Destination:=Range("A1")