Object variable Excel

[Mollethewizard]

This maybe very simple – but anyway – I’ve got a workbook with a modeless user form with a button that closes this particular workbook. Code goes like this:

Application.ActiveWorkbook.Close Savechanges:=False

That’s all right providing the workbook is activated. Is there a simple way to assign the workbook to a variable when the workbook opens that I can call later regardless what workbook is activated at the moment I press the button on the user form?

Something with an object-variable I presume...

Could someone help, please?

Mollethewizard

 

[Chance1234]

Have a look at the ThisWorkbook on open event.

Chance,

Filmmaker, taken gentleman and [insert quote here]

 

[Mollethewizard]

Chance

Talking of idiotic questions….

ThisWorkbook.Close savechanges:= False

Did the trick regardless how many other workbooks there were open.

Thanks for putting me on the right track!

Mollethewizard

 

[SkipVought]

Hi,

You might have multiple workbooks open. Each open workbook has a ThisWorkbook Object.

You could assign an Object Variable like...

  Dim wb1 as workbook

  Set wb1 = workbooks.add  ' or Open method

...

  wb1.close
  set wb1 = nothing

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More![/sub]