How to Refer to Another Excel Workbook

  • Thread starter Thread starter hon123456
  • Start date Start date
H

hon123456

Dear All,
I have a Universal VBA in Personal.xls. Now If I open
book1.xls. Then the Personal.xls will
be opened too. However , If I want to refer to book2.xls, I need to
write the following hard code in Personal.xls.

test = [book1.xls]sheet1.range("a1")

What I want is that I do not want the book1.xls to be hard code. How
can I code it to let the filename be current workbook. If my workbook
is book2.xls or book3.xls . Then the VBA should
open book2 or book3. How can I write the variables for my current
workbook. Thanks.
 
test =Activeworkbook.Worksheets("Sheet1").Range("A1")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top