Need help with VBA Code

[Zishan Siddiqui]

I created a code using VBA to generate offer letter for my organisation. I need to enter the data in the corresponding fields and click on print all button and a .docx file is generated and saved at D Location in my computer.

What I need now is that before generating docx file, I want to see the preview of the offer letter in excel only. Can any please help me?

 

[Hui]

Zishan

Firstly, Welcome to the Chandoo.org Forums

Have you seen my post at:
https://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/

 

[Zishan Siddiqui]

Hi Hui,

Thanks for sharing the details, I have seen this post and I have already created the similar type of file. What I need in addition to this mechanism is that before I create the doc (word), I want the preview of the word file in excel it self.

 

[Ashhu]

can you upload sample excel preview which you would like to see.

 

[Zishan Siddiqui]

What I basically want to do is that, With "Print All", I should have one more button as "Preview" and as soon as I click on "Preview" button letter should be generated in another worksheet of the same workbook through which I can review the details if everything is correct or not and post reviewing the same I can click "Print All" to generate the *.docx file.