Aug 15 2022 01:06 AM
When I use Workbooks.open on VBA I get this error message. How do I fix this? Would appreciate any help.
Aug 15 2022 01:36 AM
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.
I know I don't know anything (Socrates)
Aug 15 2022 03:02 AM