Hi All,
I am trying to create a code for the above query, any help will be great appreciated
Thank you
Archana Gaur
Hi All,
I am trying to create a code for the above query, any help will be great appreciated
Thank you
Archana Gaur
What is condition to copy specific cell dynamically…
As i understand you want to copy total from excel and paste into word dox after xxxxx with same format.(this format more look likr mail)
Here are the steps,
1.read data from excel into datatable.
If your data present always at last specifed cell then
Use read cell and pass following in cell parameter
“C”+ (Dt.rows.count+2).tostring. Or
Value =Dt.rows(dt.rows.count).item(2)
If it is after totals then
Dt.select(“column name=‘TOTALS’”).COPYTODATATABLE.rows(0).item(2)
Then just open doc using open application
Send hot keys for find and replace (alt+e+r please confirm this)
And change the required field.
Let me know if any thing elze is needed