I need to check some values in the MS-Word
[b]Question asked by visitor Venkat[/b]
I need to check some values in the Microsoft word document while running my script. Something like, i have a table in my word document and i have to validate a value in that table with a value in my datatable.
How do I go about doing it?
Re: I need to check some values in the MS-Word
Hi,
Check the below example for validating data in excel where we did in our project
dim excelobj,counter
counter = 1
set excelobj = createobject("excel.application")
set wbo = excelobj.workbooks.open("c:\kpi japan jhq combine report")
set wbs = excelobj.activeworkbook.worksheets("kpi japan jhq combine report")
if excelobj.cells(1,1)="kpi japan jhq combine report" then
reporter.reportevent 0,"hq cumulative report validation","hq cumulative report validation success"
else r
eporter.reportevent 1,"hq cumulative report validation","hq cumulative report validation fail"
end if
if excelobj.cells(3,4)="yesterday's" then
reporter.reportevent 0,"excel sheet data validation","excel sheet data validation success"
else
reporter.reportevent 1,"excel sheet data validation","excel sheet data validation fail"
end if
Re: I need to check some values in the MS-Word
[QUOTE=raghav.kamal;8506]Hi,
Check the below example for validating data in excel where we did in our project
dim excelobj,counter
counter = 1
set excelobj = createobject("excel.application")
set wbo = excelobj.workbooks.open("c:\kpi japan jhq combine report")
set wbs = excelobj.activeworkbook.worksheets("kpi japan jhq combine report")
if excelobj.cells(1,1)="kpi japan jhq combine report" then
reporter.reportevent 0,"hq cumulative report validation","hq cumulative report validation success"
else r
eporter.reportevent 1,"hq cumulative report validation","hq cumulative report validation fail"
end if
if excelobj.cells(3,4)="yesterday's" then
reporter.reportevent 0,"excel sheet data validation","excel sheet data validation success"
else
reporter.reportevent 1,"excel sheet data validation","excel sheet data validation fail"
end if[/QUOTE]
This code is for Excel Sheet. Not for work Document
Kindly can you give some code for Word Document