Q:

Set workbook is failing in VBA

I have this simple bit of code which I can not work out why it fails. 
The workbook TestData.xlsm is open. 
The code is failing on the line Set WBook. It is driving me batty. I need to move on to why I am writing the code. I have tried different code from the internet and everything fails. 
The error is: 

Runtime Error 424 Object required.

Public Sub specialLookUp()
   Dim WBook As Workbook
   Set WBook = Workbooks(“TestData.xlsm”)
End Sub

A:

The quotation marks are a bit odd - can you just try this:
Public Sub specialLookUp()
   Dim WBook As Workbook
   Set WBook = Workbooks("TestData.xlsm")
End Sub

