| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Refer to Another Excel Workbook
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refer to workbook | Excel Programming | |||
| How to refer to the specified sheet in the workbook? | Excel Programming | |||
| Refer to more than one worksheet in a workbook | Excel Worksheet Functions | |||
| When writing a macro in excel workbook, how do I refer to ea cell | Excel Programming | |||
| how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
Threaded Mode
