#1
|
|||
|
|||
Adding the table reference
Hi,
I am new to word VB scripts. I have a document with the tables, and i want to select some tables only. And each table is in the following format attached (input). The output needs to be in the format (output) attached. Regards Pri |
#2
|
|||
|
|||
Referencing tables in vba:
ActiveDocument.Tables(1) = 1st table in document |
#3
|
|||
|
|||
@Charles Kenyon: Could you elaborate please.
I am new to vba |
#4
|
|||
|
|||
Before any of us can effectively elaborate, you are going to have to elaborate first.
What specifically are you trying to do? |
#5
|
|||
|
|||
I have document with tables in section 9.2 And a section 9.3, with elements of table.
I want to fill the tables with the IEs in the tables of section 9.3 Lets say, in table 9.2.2.1, the "Message Type" IE has "IE type and reference" to 9.3.1.1. So i want to fill that from 9.3.1.1. If any fields in 9.3.1.1, have any other IEs and reference also needs to be filled. But lets say field "Bearer Context Status Change" doesnot have any "IE type and reference" , is just that field. And in the output, i am just interested in first two columns only. The fields (Information Element) are specified in section 9.3. The fields within these also can be nested. e.g 4th row of table 9.3.1.3 "Criticality Diagnostics" refers to 9.3.1.53. So this again needs to be filled accordingly. I have manually filled these for messages in section 9.2.1. I want to automate with script, so easier when spec version changes. |
#6
|
|||
|
|||
The table in E1output is manually filled for all messages of section 9.2.2.
I want to automate for filling in same way for 9.2.1. And also automation/script helps if any changes in fields, in later version of specs Note: im interested in filling only first two columns. some Ies in second column of my manual example is missing, it is because of my mistake. E1input is split into 5 files, as total file size exceeds the limit Last edited by pri; 04-11-2019 at 03:33 AM. Reason: corrected mistakes |
#7
|
|||
|
|||
Sorry the output file couldnot be attached
|
#8
|
||||
|
||||
Cross-posted at: http://www.vbaexpress.com/forum/show...g-nested-table
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Hello,
I understand i posted two places, but at least keep one thread free from comments, as i need help urgently. Hope you understand Thanks for your support Priya |
#10
|
|||
|
|||
Is there any inputs to this, will be helpful..i am not vba programmer, but plain old embeeded c programmer..want to use vba to create design document..
|
#11
|
||||
|
||||
Priya
It appears people are not interested in replying because the question you have raised is complex and we don't think we would learn much in doing your work for you. I believe you would have more luck if you broke this down into smaller chunks and made some initial attempts at modifying existing code you can find on this and other forums that could be adapted. Post those attempts at smaller pieces of the puzzle and I'm pretty sure people would step up and help out. You haven't specified where all these input and output documents are coming from - how does the macro determine what are the input docs and where is the output doc? Are all these documents already open or do they get opened/closed by the macro. Once you have the relevant input/output documents sorted, how do you identify the relevant source and target tables? Then how do you identify the relevant cells? Are you replacing the entire cell to the target cell or appending text? What is the iteration process for the subsequent input docs?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#12
|
|||
|
|||
@Guessed and macropod, could you delete this thread. I tried and unable to.
To make it clear my work is not to come up with the script. My work is requirements gathering and as part of this, everytime specs changes, i need to update some excel sheet. So it is easier for me if i have the script handy. So could you kindly delete this thread |
Tags |
word macros |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding reference to Office 12 Object Library to | jag_man653 | Excel Programming | 11 | 02-20-2018 03:31 PM |
How to reference more than one table in a Word doc | scootermac315 | Word VBA | 5 | 06-22-2015 05:28 PM |
Create updating reference in table | droseman | Word | 1 | 09-05-2014 05:39 PM |
Using reference table | BritBiker2 | Excel | 3 | 02-23-2013 05:27 AM |
Adding additional job/education/reference category boxes in resume template? | Audible Nectar | Word | 1 | 11-16-2012 01:16 PM |