copy info from design table to seperate file

Our company uses a custom excel design table to input partnumber, rev level, etc. We also use travelers in the shop that areexcel-based. What i'm trying to do is write a macro that opens thatfile and automatically populates the correct fields with the designtable data. And, outside of solidworks, I've been successful. BUT,if the user opens the design table inside solidworks instead of "innew window" i get a run-time error. Being an entry level VB dabbler(i wouldn't make the stretch to call myself a programmer!) I haveno idea how to work around this is issue.SolidworksApi macros