Create macro to change textbox values and export as image.

Completed Posted Mar 22, 2016 Paid on delivery
Completed 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.

Excel PHP Software Architecture Visual Basic

Project ID: #10015841

About the project

3 proposals Remote project Active Mar 22, 2016

Awarded to:

OGurev

I'be solved similar task when made vacation calendar for my department. Several hour to make it after you send me example.

$15 AUD in 3 days
(0 Reviews)
0.0

3 freelancers are bidding on average $30 for this job

prashantbjadhav

Hi there I have worked on excels a lot. Recently have completed excl related programming tasks. We can discuss Regards

$35 AUD in 1 day
(2 Reviews)
1.9