Create macro to change textbox values and export as image.
$10-30 AUD
Paid on delivery
Cover Template and Resizing Macro
Title: Create macro to change textbox values and export as image.
Description:
I have an image of a book cover in Excel, and using Excel's text box tool, I also have three fields: Title, Author and Description. These fields are inside text boxes which are positioned in front of the supplied book cover image.
I have five columns of data which will be supplied. The columns are: Title, Author, and Description, Horizontal Dimensions and Vertical Dimensions.
The macro needs to do the following:
Using the values in the Title, Author and Description columns, change the text inside the text boxes, going down the rows of each column consecutively. The book image, (which includes the text boxes) should then be resized based on the values labelled in the horizontal and vertical columns. The macro should then export this image, preferably as a print-ready pdf or high quality image format.
Examples of what the macro needs to do can be provided.
This can be done either as one or two macros, however it is essential that this macro is as automatic as possible as it eventually will be used to create hundreds of covers. The source code should be supplied and commented so it can be used for other projects in the future.
First task: convert an archive of .doc files to .pdf then supply the page numbers of each pdf and file in an excel sheet.
Project ID: #10015841
About the project
Awarded to:
I'be solved similar task when made vacation calendar for my department. Several hour to make it after you send me example.
3 freelancers are bidding on average $30 for this job
Hi there I have worked on excels a lot. Recently have completed excl related programming tasks. We can discuss Regards