Actually i have given the table name and like this i did.
sub gen_qvd rem ** show each possible value in list box **
set docprop = ActiveDocument.GetProperties set LB = ActiveDocument.GetSheetObject("LB02") boxvalues=LB.GetPossibleValues for i = lbound(boxvalues) to ubound(boxvalues) if boxvalues(i) = "Customers" then ' Replace the text with the Table name (Case Sensitive)
docprop.Script = docprop.Script & chr(10) & "Store " & boxvalues(i) & " Into ../" & boxvalues(i) & ".qvd where CustomerID>20;"
sub gen_qvd rem ** show each possible value in list box **
set docprop = ActiveDocument.GetProperties set LB = ActiveDocument.GetSheetObject("LB01") boxvalues=LB.GetPossibleValues for i = lbound(boxvalues) to ubound(boxvalues) if boxvalues(i) = "Customers" then ' Replace the text with the Table name (Case Sensitive)
Thanks a lot for your reply. Your code is working excellently but small change is required we need to keep Qualify * before Resident load. B'coz we are already loaded 'selected table in edit script'.
But how can i pass dynamic conditon for different fields in table. Instead of placing condition in the script can we provide from front end dynamically.
sub gen_qvd
rem ** show each possible value in list box **
set docprop = ActiveDocument.GetProperties set LB = ActiveDocument.GetSheetObject("LB01") boxvalues=LB.GetPossibleValues for i = lbound(boxvalues) to ubound(boxvalues) if boxvalues(i) = "Customers" then ' Replace the text with the Table name (Case Sensitive)
Right now the code is working but think about i have some tables in my listbox , each and every time i have to write the particular table name in the macrocode and write the condition for that table field .this could not be userfriendly.
so, what i am thinking is after selecting a particular table from the listbox the corresponding fields of that table should be displayed in another listbox and from that i can select any one field and the condition should be supplied through button click apply the condition on that accordingly.
Now what i want is when i selecting a table from the listbox the particular table ,that table name should be placed in the macrocode automatically where the table name required.In the same way for the field selection and also the condition comming from the button click automatically.
If you had any questions regarding my requirement please reply me .I will try to explain clearly.
