View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Qasim Ahmad Qasim Ahmad is offline
external usenet poster
 
Posts: 3
Default code to check for project references in VBA

Hi everyone,

Can someone please help me out here. I'm trying to check is all the
project references are valid for a VBA piece of code i have written
and need to distribute. Currently, if there is a broken reference,
the vba just ends up spiting out a runtime error. Is there an elegant
way to check for this through the code. I did see examples using
VBPRoject, but i am not using this object. im using pure vba.
Thanks in advance :)