Wish I could have found a reference for the VBProject object model somewhere on the web, but no luck.įrom numerous searches, bits-and-pieces gleaned from here-and-there, and lots of trial-and-error, I came up with this. Thank you.Installing a custom COM error handler yields the problem: Has anyone had any experience using the VBProject objects? I'm getting a "The requested action with this object has failed." error with the caret pointing between "VBProject" and "VBComponents".ĭoes Excel not automatically have access to the VBIDE object models? Will I need to reference the VBIDE DLL directly? Something like the following was my best guess: I have an update for that macro and wanted to write a script to pass through all the directories and replace the macros. I have about 10,000 Excel spreadsheets that all contain the same small embedded macro.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |