how can i test for module1 (and userforms) and delete them if they are found

i have a macro that in part, copies module1 and userforms1-3 to a target workbook. what i want to do now is test for module1 in the target workbook and delete it if found. same for userforms.

here is my macro.

Please Login or Register  to view this content.

See this page for all the information you'll need, including a function to check existence of a module

thanks cytop, but I will still need a little bit of help. i read through the whole article and still am not sure how to make this happen.

i used the function VBComponentExists(VBCompName As String, Optional VBProj As VBIDE.VBProject = Nothing) but all it does is bring up the run macro dialog box.

what am i doing wrong?

No idea. Post a sample of the workbook with the Check function included.

ok, here it is.

you can click on the sheet and choose the button labeled "Import Sheets". that kicks off the "startSaveModule" macro. you might have to set up folders to match where I am putting the module/userform code.

First off - you have added a reference to the 'Microsoft Visual Basic Extensibility library as mentioned on that page?

Other than that, as long as you pass a reference to the project in the new workbook, it works after the code from Chip Pearson was added.

Please Login or Register  to view this content.

thanks cytop, that will work for me. appreciate the help.

so this is what i did to fix the issue:

Please Login or Register  to view this content.

can this be simplified?