Transfer data from excel form to word document

[aman1234]

Hi guys

My project is built in Excel. I just want to transfer the policy number from excel form ro word document. The word document is saved in a folder and it depicts the information in some letter format. I want to transfer the policy number from excel form to ms word document page 1 and then print off the document . But no idea how to do that. I figured how to print off the document as follows but don't know how to transfer the policy number in that.

Please Login or Register  to view this content.

Any help would be much appreciated.

Thanks

[TMS]

The following code is from another project (and forum response) and is unmodified. It will, hopefully, give you some ideas:

Please Login or Register  to view this content.

The workbook and worksheet details are passed to the subroutine. It does some tweaking and formatting before copying the data to a newly created word document.

Regards

[aman1234]

Hi

Thanks for your reply. Can anyone please modify the code accordingly?

Thanks

[aman1234]

Hi guys

I have written the following code to copy the textbox value from excel form to word document but it is not doing that but simply printing off the word document.

Please Login or Register  to view this content.

Any help would be much appreciated.

Thanks

[TMS]

I provided some code which does some processing in the Excel file, copies some data from the Excel file, creates a Word document, pastes the data into the Word document and does some formatting in the Word document.

In post number 3, you said, "Can anyone please modify the code accordingly?" Apart from you, I suspect nobody knows what that means. You haven't uploaded the original workbook, or the Word document, or given any indication of what data is being copied from the Excel document nor where it needs to go in the Word document.

Your modified code selects a shape, adds some text to it and prints the document. I'm seriously getting the impression that you didn't put much effort into taking the sample code provided and trying to make it meet your needs.

Sorry, I'm out.

Regards

[aman1234]

Hi

Thanks for your reply.As I have never done copy and paste from excel to word using vba so don't understand really what I have to do. But based upon the code you sent me over, I have written the following line of code which does copy and paste but it does paste the value on the top of the MS word document but I want it to paste the value at specific position in WOrd document.

Please Login or Register  to view this content.

I hope you can point me in the right direction.

Thanks a lot for your help so far.