Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two requirements:
1. To save specific fields and not all the fields from a Table-Box into QVD.
2. The resultant QVD should have that many different fields as are saved in the step above (and not one field).
For example, my table-box may contain 5 Fields. F1, F2, F3, F4 and F5.
I need to write macro to pick only F4 and F5 from table-box and save it as two different fields (and 'not' concatenated as one field) in a QVD.
From community I came to know about the following piece: But, It saves the whole Table-Box and all fields are concatenated as a single field in the QVD
set obj = ActiveDocument.GetSheetObject("TB01")
obj.Export "D:\Developer\Cash\Sett.qvd", 4
Create another table box with only the fields you need and export that table box with your macro. You can hide the table box so the users won't see it.
Thanks for your reply.
Approach you suggested helps me except a condition. My table-box actually contains a column as INPUTFIELD (takes user input). And I have another column that contains the RowNo. So, I want to store these two columns only, from TableBox, once the user finishes all the inputs. Therefore the value of a column in not known during reload and that stops me to create a sperate hidden table.
I don't understand why the inputfield would stop you from creating two table boxes and hiding one of them. Can you explain that?
Hi Gysbert.
I am not sure if I explained my problem in right direction. But, if InputField is one among many fields inside a table box, how then we can select this particular InputField and save it in a seperate table-box. I want to achieve this at the button click event (external-macro). Please let me know if I need to produce an example to understand this in a better way.
ID | TicketNo | Currency | Paid | Rcvd | Balance | Relevant_TXN_ID |
---|---|---|---|---|---|---|
1 | US320 | USD | 200 | 3 | ||
2 | US324 | USD | -110 | 3 | ||
3 | TXN401 | 90 | 3 | |||
4 | UK119 | EUR | 176 | 7 | ||
5 | UK121 | EUR | -76 | 7 | ||
6 | UK128 | EUR | -100 | 7 | ||
7 | TXN431 | 0 | 7 |
Can anyone please help me with this issue?