Description of every module: Basically I have a word template and 13 images and a text change that need to be inserted into the report.
This will need to be repeated around 160 times so am looking to put in place some VB automation.
I will have a subfolderwith the images set up for each report iteration.
Description of requirements/functionality: Basically I have a word template and 13 images and a text change that need to be inserted into the report and the report saved as both Word and a pdf.
This will need to be repeated around 160 times so I want you to put in place some VB automation.
The images are the same size everytime in each report.
Specific technologies required: MSOffice VBA
OS requirements: Windows
Extra notes: I have attached the template and 2 sample images. THe images changing are the bar charts, the MSQ quadrant and the titel on the first page.
There may be a couple of very minor tweaks to the template before we start and also there will be 7 versions of it in all with different versions ofthe table pre populated.
Peter C.100% (2)
Create an account now and send a proposal now to get this job.Sign up
Clarification Board Ask a Question
I would need to see more of a sample of the 160 documents, to check they have the same/similar image names etc.
Also, is it the same image files to be used each time, or they are different for each of the 160 documents?
How are the files stored and referenced to each other - ie how will I know which 160 documents need to be opened and altered/saved etc?Peter C.05 Apr 2017
The 160 reports are for individual stores. There are 7 template files (1 per Region). The images are called by the store name/number then image 1 . image 2 etc if that makes sense. THe function should take a base file Template1 and then add the images all relating to 0570 Peterborough and drop them into the template and save as 0570 Peterborough.doc and as 0570 Peterborough.pdf.
Does that help?Mark R.05 Apr 2017
Are you open to the idea of having a Excel or Access file to control the automation process. Excel would give us somewhere to store variables such as file locations, store values, templates to be used, pictures to be replaced etc. Otherwise hard coding into a Word macro or similar would limit the automation process and make it more difficult to alter and error check.