Mutli Tab Drawing Title Block Update Routine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi,
I'm currently working on a single tab drawing based project but would like to switch over to multi tabbed drawings.
Though currently the csv based drawing register I am using for title block updates doesn't have the functionality to work across multilpe tabs.
I've previously worked with a company that had a drawing register and routine that worked across multiple tabs and would like to reproduce something similar. Basically the routine worked by reading a text file which was placed in the same location as the drawing files and contained a link to the excel spreadsheet register. From that point it would search the register for the drawing file(s) the routine had been told to run over, locate the layout tab name for the drawing file and then update the titleblock attributes to match the data in the register. I believe it was a VBA routine.
Unfortunately I do not know enough about VBA or coding to create a similar routine and hence am hoping someone here can potentially give me some advice or point me in the right direction. Surely this is not a unique problem and has been solved many times in the past.
Some screen shots to help give an idea how the multi tab routine worked;
Draqwing File Name
Layout Tab Names
Title Block Attributes
Sample Register
Update Title Block Tab 0001