【转帖】macro troubleshooting

yang686526

macro troubleshooting
i downloaded a renaming macro (thanks, fcsuper!), that won't work on my machine. i get an error message telling me that i have a compile error, can't find project or library. unfortunately, i'm a complete moron when it comes to vb...if anyone can shed some light on this, it would be greatly appreciated.
jeff mirisola, cswp, certified driveworks ae
i guess it would help to provide the file...
jeff mirisola, cswp, certified driveworks ae
i'm not sure about the "project" aspect, but the libraries can be set when editing the macro via tools > references. just select the libraries which match your sw version.   

most likely you have a reference issue caused by the macro being created in a different version from the one you are running.  in the vba editor, go to tools->references.  in the list there will probably be a few checked entries that say "missing:______".  un-check those and find the corresponding entries in the list for your current version of sw and check those boxes.   
-handleman, cswp (the new, easy test)
handleman,
i found one instance of "missing:" but i can't find any corresponding entries. if i deselect the missing one and rerun the macro, i get another error message that, to me, implies that the user form is missing.
also, if i shut down sw and restart, when i initially run the macro i get an microsoft forms error stating: 'could not load object because it is not available on this machine.'
thoughts?
jeff mirisola, cswp, certified driveworks ae
jmirisola,
rename.swp was built using a library reference to something called "microsoft masked edit control 6.0". this or an older version does not appear in my reference library either. - maybe it is from the vista operating system. i'm still using xp. how about you?
just my guess  .
tobin sparks
i'm still using xp as well. i've looked around for the msmask32.ocx file and it's not on my system, nor have i been able to find a reputable site to download it from.   
jeff mirisola, cswp, certified driveworks ae
tobin has hit it on the head.  no comments as to whether it's legal or not, but
ok, got it. too bad the damn macro still won't work. i still get a compile error: can't find project or library.  
jeff mirisola, cswp, certified driveworks ae
a lot of those ms files are all over the net.  if this macro is having this kind of issue though, i'll remove it (its an example from the sw website anyway).   
matt lorono
cad engineer/ecn analyst
silicon valley, ca
i'm getting closer, but still no dice. i don't know that there's anything too wrong with the macro, matt. i don't know enough about vb to determine that.
jeff mirisola, cswp, certified driveworks ae