Copy specific cell (dynamic) from Excel and Past it on Word at a specific place

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

1 Like

@rahatadi Great thanks, Aditya!
And many many happy returns of the day!
:slight_smile:

@gaurar

Most welcome…
And thnax for wishes…:blush:

1 Like