Search results
11 sie 2019 · Following up on Chris' thought: You can try File->Export to see if the VBA Editor can create *.bas files from the modules. If it can, then these can be imported into a new project (the code won't be lost)... Another thing you can try is to save the document under a new name with Save As.
5 sie 2015 · Could the problem be down to particular VBA library not available on Excel version in the office? Visual Basic For Applications. Microsoft Excel 16.0 Object Library. OLE Automation. Microsoft Office 16.0 Object Library. You should check for the versions of OS and Excel and contact IT if they have integrated any update as of late.
6 sty 2016 · If a workbook is trying to run a macro that contains objects they are not included in the references section of the VBA editor, this kind of error could happen. For example, if it requires a specific DLL to be correctly registered on the PC.
25 lut 2021 · It seem that with some macro workbooks, when I save, close and then reopen them, the worksheet and workbook objects get duplicated with an additional '1' appended to their names. The new objects become the active objects.
16 cze 2024 · In this article, you will 2 possible solutions when Object variable or with Block variable is not set in Excel VBA.
20 mar 2019 · You may note that the icon for those non-existent sheets is actually the icon for the ThisWorkbook object, which is usually a sign of corruption, as has been mentioned. Since you only have two sheets, and assuming you see the same thing after restarting Excel and opening the workbook, I'd try copying the contents of each sheet to a new workbook.
21 maj 2024 · Solution: Insert the Correct Worksheet Name. Rename the sheet to avoid the Application-Defined or Object-Defined error in Excel VBA. You can see the correct VBA code in the below image. Read More: VBA Object Variable or with Block Variable Not Set in Excel.
