Macro to Get Data from xls and insert them in Word embedded xls sheet

[Adnane]

Hi,
what i'm actually trying to do is the following. i have an Excel product pricelist (containing the SKU, product name, Price,...). on the other side, i have a .doc template for propsals to customers that contain an embedded Excel sheet to put in the products the customers is interested in buying. i'm currently trying to have a macro (to be lauched from Excel)that will proceed as follow:
1-the user enters the quantities in front of every concerned product (in Excel)
2-the macro will scan the sheet and get the SKU, the product name, and the price of this reference that has a quantity in front of it
3-insert this info in Word
4-delete the quantity entered in Excel
5-go to the next reference and so on.

i have been able to do this with an Excel template but it looks so much better in Word, so i would appreciate your help doing this.

Regards,

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[SkipVought]

Hi,

What were the formatting deficiencies of the Excel proposal template that made your choose the Word proposal template?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Adnane]

Skip,
there aren"t any major formatting deficiencies in Excel. the main reasons why i wanted to switch to Word are:
1- all the telesales are used to work with the word template (except that they used to do it manually)
2-their boss likes the word template (so now i have to convince him to use the Excel one :-( )
3- it would have been a great opportunity for me to learn new things or at least have an insight on how to make the two apps communicate to each other

Thanks though

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[SkipVought]

You know that it's possible to use a screwdriver to pound a nail into a board...

1. Actually, you need TWO screwdrivers.

2. Use the 2 screwdrivers to pick up a hammer. Caution: protect the surface from falling hammer.

3. Position the hammer over the nail. BTW, you might need 2 or 3 more screwdrivers to keep the nail in a vertical position.

4. Raise the hammer far enough above the head of the nail, so that the potential energy of the falling hammer under the influence of gravity will have enough momentum in order to cause the nail to proceed into the medium. (see Newton's laws, and calculations regarding acceleration, mass, momentum and other like stuff)

But I would NOT recommend this approch! ;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Adnane]

Skip, was that supposed to be funny?? i'm afraid i didn't get the point!

anyways,...

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[SkipVought]

Your tools are Word, Excel etc.

You choose the tool appropriate for the job.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com