VBA Set command throwing up Run-time error 9

[kctronic]

Good day, I have had a workbook that i have been using for the past 8 months. Suddenly in the past 24 hours the VBA command line below began throwing up Run-time error 9. All workbooks exist and this error is occurring across a lot of similar workbooks i use. Was it an update? How can i fix this issue?

Dim credi As Worksheet: Set credi = Workbooks("TestWorkbook").Sheets("Credi")

 

[Fluff]

Hi & welcome to MrExcel.
You need to add the file extension to the end of the workbook name.

 

[kctronic]

Thanks a million!

 

[Fluff]

You're welcome & thanks for the feedback.

I suspect that your explorer settings changed, if you have "Hide known file extensions" checked then you don't need to use the extension (although it's best to always include it), however if it is unchecked then you must always include the extension.

 

[kctronic]

For some weird reason file extensions are displayed though the "Hide known file extensions" is checked. Started after a recent OS update. Working with file extensions in the VBA would do. Thanks once again!

 

[Fluff]

My pleasure.