How to Refer to Another Excel Workbook

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.
 
B

Bob Phillips

test =Activeworkbook.Worksheets("Sheet1").Range("A1")


--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with activating window from Application.GetOpenFilename 4
Hiding an item in the taskbar 1
How to validate path? --- bValidatePath ("") Then 7
Calling excel macro not located in that workbook. 2
Change workbook name to a generic name 4
Subject out of range 3
VBA to open a shortcut to a workbook 3
Find WkBk Path, Then use this path to open another WkBk in Subfold 10

Top