Quote:
Originally Posted by macropod
A few questions:
1. Why an embedded Word document, rather than a Word template stored in the same folder as the workbook?
2. Does the Excel table always span the same range?
3. Why does your last code block loop through all tables in the document instead of processing just the one that's being inserted/updated?
|
Hi macropod in answer to your questions:
1. We send the template out to our field staff. its designed in such a way they can download in anywhere onto their PC / tablet and can run the program. Basically saves us writing a separate install program.
2. There are approximately 20 tables ad all bar one span the same range
3. No particular reason... just the way the program was coded.