extracting data from a database and excel spreadsheet

[demo]

I am generating as built drawings and have automated various routines. One
that I am currently working on involves importing data from an Excel
spreadsheet and an Access DB. If I can figure out one I can probably do the
other. I would like to evaluate the xls sheet for number of rows then based
on that data create an appropriate number of new sheets then paste the rows
into the new sheets. I would like to do this into text blocks with user
selectable attributes such as font type, size, alignment, etc... Thanks in
advance... Derek

 

[Al Edlund]

there were a number of very good examples created for visio that are still
on msdn. I'd start with this one

http://msdn.microsoft.com/library/en-us/dnvisio00/html/netconfig.asp?frame=true

there were also some great examples of office integration in David Edson's
book

http://www.amazon.com/gp/product/067231813X/104-2557172-2411117?v=glance&n=283155

al