'GS[_2_ Wrote:
;1620728']Can you explain why you open a specific workbook and clear
the target
sheet? Could you not just use a new workbook?



I am using a specific workbook because I have other tabs in the WB
that has information from a field panel. I am updating the
attributes in the dwg with the actual information from the field
panel description.

Example: the field technician will put a description and extended
labels of a device that the engineer would have to update as part of
the as-builts.
The intent is to automate that process by updating the dwgAttribute
tab and then updating the drawing


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

Makes sense!
Can you provide me sample contents of Array1?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion