m_in_spain
Board Regular
- Joined
- Sep 28, 2018
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Hi Everyone.
Firstly let me say I am completely new to this and have found this forum just today. I have scratched around but cannot find some code for what i am trying to do.
Next is the advance apologies if there already is an answer to this and also if i have not described my problem/what i have done/want to do very clearly. I usually do get better with practice!
I have for years working with a 20 worksheet excel file to produce a costing. Recently i started to "automate" it so that for a few choices on an input page, I can produce a costing sheet for the items wanted by any particular customer. Nothing too hard there.
I then thought it would be nice to take my standard Word document to produce a quotation. After a lot of internet searching i discovered this was possible using bookmarks in Word. It is all going swimmingly. I managed to find, modify and insert my first ever bit of code, so which i click my "make doc" button, the word template opens the data from excel goes in and i have my document.
Next comes the part which is foxing me.
I discovered how to select one of 8 different pictures I have stored in an excel worksheet called pictures, depending on the value of a certain cell, this picture corresponds to the particular unit i have costed. I can then copy the correct picture to another worksheet i have made called transfer, (ready to transfer to my word doc)
What i am now trying to do is to take that picture and insert it into a particular place in the Word document at the same time as I send over the mentioned data. Once i have this for one picture, i need to repeat it many times with other pictures to complete my document.
Sorry for such a long winded question, ANY help will be greatly appreciated, please make any answers simple for old me to understand!
Many many thanks
Firstly let me say I am completely new to this and have found this forum just today. I have scratched around but cannot find some code for what i am trying to do.
Next is the advance apologies if there already is an answer to this and also if i have not described my problem/what i have done/want to do very clearly. I usually do get better with practice!
I have for years working with a 20 worksheet excel file to produce a costing. Recently i started to "automate" it so that for a few choices on an input page, I can produce a costing sheet for the items wanted by any particular customer. Nothing too hard there.
I then thought it would be nice to take my standard Word document to produce a quotation. After a lot of internet searching i discovered this was possible using bookmarks in Word. It is all going swimmingly. I managed to find, modify and insert my first ever bit of code, so which i click my "make doc" button, the word template opens the data from excel goes in and i have my document.
Next comes the part which is foxing me.
I discovered how to select one of 8 different pictures I have stored in an excel worksheet called pictures, depending on the value of a certain cell, this picture corresponds to the particular unit i have costed. I can then copy the correct picture to another worksheet i have made called transfer, (ready to transfer to my word doc)
What i am now trying to do is to take that picture and insert it into a particular place in the Word document at the same time as I send over the mentioned data. Once i have this for one picture, i need to repeat it many times with other pictures to complete my document.
Sorry for such a long winded question, ANY help will be greatly appreciated, please make any answers simple for old me to understand!
Many many thanks