B
Bonsai Bill
In writing a book the publisher wants a table of all book figures along with
release information. To make the task less painful I would like to have a
macro that pulls figure numbers and captions and puts them into a two column
table. Ideally, I would like to be able to open a chapter (each chapter is a
separate file) and then have macro pull captions and concatenate them into
another file containing a table. (I must combine final chapters for publisher
when finished but that is months away and it often takes months to obtain
releases.)
Each figure needs to go on a separate row. If it makes coding easier, I can
first generate a list of figures in each chapter. I started to manually do
this process but found it tedious. I have 20 chapters plus an appendix. Some
chapters have up to 25 figures.
Any suggested VBA code would be most welcomed!
Thanks
release information. To make the task less painful I would like to have a
macro that pulls figure numbers and captions and puts them into a two column
table. Ideally, I would like to be able to open a chapter (each chapter is a
separate file) and then have macro pull captions and concatenate them into
another file containing a table. (I must combine final chapters for publisher
when finished but that is months away and it often takes months to obtain
releases.)
Each figure needs to go on a separate row. If it makes coding easier, I can
first generate a list of figures in each chapter. I started to manually do
this process but found it tedious. I have 20 chapters plus an appendix. Some
chapters have up to 25 figures.
Any suggested VBA code would be most welcomed!
Thanks