Accessing multiple workbooks through a macro

The easiest way to see how to do things is to use the macro recorder. This will generate a macro for you with all the relevant properties and methods.

You can then use this as a base to write fully functional code that accepts parameters and all the other bells and whistles you can put in yourself (A good bookm on VBA would help).

To access the recorder, use Tools->Macro->Record New Macro. To access the Vb editor to see the monster you've created use Tools->Macro->VB Editor.

Regards

Rich

suppose what a.xls is the workbook which has the macro, and b.xls is the workbook you want to access, there is two ways to code depending on b.xls file is opened or it is not opened

if b.xls is opened

then you can access by using:
workbooks("b.xls").activate
then you can directly go into the worksheets
worksheets("Sheet1").select
T=RANGE("A2").VALUE

if b.xls is not opened

then you have to open it to access the workbook, you can open it using macro code, let say that b.xls is in c:\

then
Workbooks.Open Filename:="c:\b.xls" 'opens the file
and then follow the previous code
workbooks("b.xls").activate
then you can directly go into the worksheets
worksheets("Sheet1").select
T=RANGE("A2").VALUE

you can save and close the workbook by using
workbooks("b.xls").save
workbooks("b.xls").close

Thanks, that fixed it. One more question, sorry. In one of the workbooks, I have multiple sheets with the format String-1, String-2, String-3, etc. I want to access them each in turn through a for loop. Can I simply have a counter and access the worksheet by doing Worksheets("String-" + counter).Select?

yes you can use

for counter=1 to 3
Worksheets("String-" & counter).Select
'more code
next

Great, thanks. I may have a couple of other questions, and I'll post them here if I can't find the answer myself