Saving data in excel in a word file

[RASIKA99]

Guys,

I have few tables in a excel workbook named "profit calc". I want to open a new word document in the name of " profit of+(current month)" and copy those tables to word file and save it in my D:\ drive.
current month is stated in cell E3 in "sheet1" of excel file.

How can do this by using a macro or a vba code?

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.