+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Send Data from MSWord document 2 Excel File (/Thread-Send-Data-from-MSWord-document-2-Excel-File)
Send Data from MSWord document 2 Excel File - kisskasa - 01-10-2012
Hi,
Please Send me the Code -
I have a MSword Document, The document is as follows -
File Name --- abc.doc
Data In the file -
Defect ID: QCCR1J19136
Problem: Not all fields in the new Requirement dialog box are accessible from workflow's Run_New.Not all fields in the new Requirement dialog box are
accessible from workflow's Run_New.
Solution: The problem is fixed.
Limitation: None.
Defect ID: QCCR1J19185;45678abcderr
Problem: Requirements report with Trace to Sub reports is not working as expected.
Solution: The problem is fixed.
Limitation: None.
Defect ID: QCCR1J19128
Problem: Status values are displayed instead of Test Plan folders when using the 'Generate Tests' option from Requirements.
Solution: The problem is fixed.
Limitation: None.
Defect ID: QCCR1J19136
Problem: Not all fields in the new Requirement dialog box are accessible from workflow's Run_New.Not all fields in the new Requirement dialog box are
accessible from workflow's Run_New.
Solution: The problem is fixed.
Limitation: None.
Defect ID: QCCR1J19185;45678abcderr
Problem: Requirements report with Trace to Sub reports is not working as expected.
Solution: The problem is fixed.
Limitation: None.
Defect ID: QCCR1J19128
Problem: Status values are displayed instead of Test Plan folders when using the 'Generate Tests' option from Requirements.
Solution: The problem is fixed.
Limitation: None..........
Now my requirement is to send all the data to the excel file in the below format -
And so on like this need to append to excel, My data is very large in MSword document.
In the excel, i need 4 columns like Defectid, Problem, Solution, Limitation under that columns, i should get all the data
Please find the sample Excel document.
i need in to the excel. Please find the attachment.