Exerpt from 11/14/2006 post "Code that will delete certain tables in a document ..."

D

Doctorjones_md

Jean,

Thank you for the code -- it work GREAT! I have a couple of additional
questions:

#1 -- If the Summary table wasn't the last Table in the Active Document,
would could you designate the specific table?

#2 -- Could I use this same method (or something similar) to copy data from
certain cells in the tables we summed? (for example --in Tables 1-13 I have
the following fields [Product Name], [Description], [Price], [Quantity],
[Delivery Cost] and I'd like to exclude the multi-lined description and
insert only the Product Name, in Cell(1,1) (Set rgeCell =
tblsDocument(i).Cell(1, 1).Range) -- Additionally, if the Quantity >1, then
I need the product of Price x Quantity

Much Thanks in Advance for all your help

Shane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read text from table in a document, place it in a userform label,then delete the table 2
userform control structure strategy help request 0
Table relationships between 42 tables 4
Update one field from one table to another field in another table. 2
Find Keyword, Copy Table, and Place in New Document (almost workin 1
Select data from two tables 2
Code that will delete certain tables in a document, and SUM 3 columns in the remaining Tables 9
Include additional fields in or from a totals qry 12

Top