Workbooks.Open Function

[raven1124]

Hello Everyone,

It's seems so dumb to ask but I can't figure out why I am getting this error message:

What I'm trying to do is open another workbook using the path that I provided.

ERROR MESSAGE: Run-time error '13': Type mismatch

Dim wsDatabase As Worksheet
Dim path As String
path = "[location of the file]"
Set wsDatabase = Application.Workbooks.Open(path)

Also, if someone can explain to me why this is happening so that I can avoid these errors from happening again.
Thanks in advance and I appreciate your time reading this thread.

 

[Dim Me as xlNoob]

Hi lucky this is a simple one! You're trying to assign a workbook to a worksheet object. Replace the first line with the line below and you shouldn't have any issues.

Dim wsDatabase As Workbook