Hi

Try

set basebook = Active.Workbook

Regards

Andrew b


Blogd_Node wrote:


Hi,

Just starting coding VB in Excel.
Am more familiar with Access, so I know
just enough VB to be dangerous to myself...
:-)

I have a macro (in PERSONAL.XLS) which is run from within TEST.XLS.

In the line of code
set basebook = thisworkbook

"ThisWorkbook" refers to personal.xls and NOT test.xls.

How do I refer to the TEST.XLS ?

Many thanks

David