Excel VBA basics

[Philipp]

Hello,
I wonder why the following Excel VBA code does not work.

Sub test()
Dim myBook As Workbook
myBook = ActiveWorkbook
Debug.Print "the book name is" & myBook.Name
End Sub

Is it not possible to assign the reference to the workbook to a variable?
Thanks for answers Phil

 

[Haldun Alay]

Hi,
Try


.......
Set myBook = ActiveWorkbook
........


Kind Regards.
--
Haldun Alay
"Philipp" <[email protected]>, haber iletisinde sunlari yazdi:[email protected]...
Hello,
I wonder why the following Excel VBA code does not work.

Sub test()
Dim myBook As Workbook
myBook = ActiveWorkbook
Debug.Print "the book name is" & myBook.Name
End Sub

Is it not possible to assign the reference to the workbook to a variable?
Thanks for answers Phil

 

[Andy Pope]

Hi,

You need to use the Set command as it is an object variable.

Set myBook = ActiveWorkbook

Cheers
Andy

 

[Philipp]

Hi,
Try


......
Set myBook = ActiveWorkbook
.......

OK that worked. Thank you for your prompt answers. Phil