ThisWorkBook problem

[Blogd_Node]

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

 

[Andrew B]

Hi

Try

set basebook = Active.Workbook

Regards

Andrew b


Blogd_Node wrote:

 

[Tom Ogilvy]

set basebook = Workbooks("Test.xls")

if it isn't always test.xls but it will be the active workbook

set basebook = ActiveWorkbook

 

[Blogd_Node]

Thanks Tom / Andrew.

Works fine now! Much appreciated !

===============================