[Aj_old]

Try this!

[smartcard]

Originally Posted by Aj_old

Try this!

Thanks, this is cool. But I was expecting that I can modify the DOC template the way I want, like adding more fields, repositioning the fields etc.

[Aj_old]

You can change it! The data will be allways stored in the second cell of the second row of the first table, at the 3 paragraph! Everything else can be changed

[smartcard]

Originally Posted by Aj_old

You can change it! The data will be allways stored in the second cell of the second row of the first table, at the 3 paragraph! Everything else can be changed

Thanks, I will try it.

Is it easy to do the "separate worksheet" data population than using the DOC?

[Aj_old]

Originally Posted by smartcard

Is it easy to do the "separate worksheet" data population than using the DOC?

It depends on what you wanna be on that sheet. In many cases it's easier to make a separate sheet, than to export to word!

[smartcard]

Originally Posted by Aj_old

It depends on what you wanna be on that sheet. In many cases it's easier to make a separate sheet, than to export to word!

Please find in the enclosed I have created the 2nd sheet how the populated sheet should look like, the Yellow highlighted cells will have data from the main sheet.

[Aj_old]

Is this fine?

[smartcard]

Originally Posted by Aj_old

Is this fine?

This is very very cool, that is what I wanted

Please tell me if I need to do some modification should I use Macros or any other way?

[Aj_old]

Originally Posted by smartcard

This is very very cool, that is what I wanted

Please tell me if I need to do some modification should I use Macros or any other way?

I proposed from the stat to use, excel, you said no!
It is done using a macro, and if the data structure is change the macro should be changed too!

[smartcard]

Originally Posted by Aj_old

I proposed from the stat to use, excel, you said no!
It is done using a macro, and if the data structure is change the macro should be changed too!

You are correct, its my mistake not considering your proposal.

I have seen the codes from Tools | Macros | Visual Basic Editor

Please tell me how to remove the "Export to Word" Button

Also I need to know how can I copy this VB script (macro) to another new Excel file?

Thanks for your help.

[Aj_old]

Originally Posted by smartcard

Please tell me how to remove the "Export to Word" Button

Go to Tools/Macro/Visual Basic Editor, in editor hit Run\Design Mode, return to Excel, right click the button and select delete or just click on it and hit delete

Originally Posted by smartcard

Also I need to know how can I copy this VB script (macro) to another new Excel file?

Copy the sheet, right click on the sheets tab, select "Move or Copy...", check the "Create a copy", select the workbook you wanna sheet to be copied to, and press OK. (For a new Workbook select "(new book)"!