Forum Discussion

blink1282

Copper Contributor

Aug 15, 2022

Workbooks.open not working

When I use Workbooks.open on VBA I get this error message. How do I fix this? Would appreciate any help.

Macros and VBA

NikolinoDE

Platinum Contributor

Aug 15, 2022

blink1282

Object Doesn't Support this Property or Method

VBA error 438 occurs when you try to use a property or method that does not support by that object. the objects have some properties and methods that you can use but there could be a issue when using a property or method that does not apply to a particular object.

1. You could try disabling all add-ins one by one first to see if it's causing it from there.

2. Put the code in a module and start the workbook from new so you could see the line where the error occurs.Trace code execution

Otherwise, I recommend uploading/sharing the file (without sensitive data) or displaying the code where it is hanging (performing individual steps and attaching a photo) in order to be able to say more precisely.

Hope I was able to help you with this information.

NikolinoDE

I know I don't know anything (Socrates)

blink1282

Copper Contributor

Aug 15, 2022

Thanks for the help NikolinoDE. I have been able to solve the problem in that it opens my workbook but it stops the code and still gives the same error message. And so I am unable to continue the rest of my code.