Results 1 to 4 of 4

Thread: Macro - Import, Resize, Adjust Format, Position, Insert Text Box and Lines

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    Question Macro - Import, Resize, Adjust Format, Position, Insert Text Box and Lines

    Hello,

    This is my first time on these forums! I have a challenge for those of you that are really good with macros. I am a beginner with macros and would like to use them to make my work a little easier. I have a multitude of images of cells that I have to import into word, change the format to tight, resize each image, equally space them on a sheet, insert lines to differentiate each picture from another one, and then add a text box at the bottom of each of these images to add what type of cells they are. I would like this to be done automatically with the click of a macro function if possible. Please see the image below for an example! I have code to change the size of these images and to import them, but I don't know how to add everything else or even these codes to the new codes. If someone could help me do the following procedures in this sequential order, I would very much appreciate it:

    1) Import a specific folder of pictures, 2) select all of these pictures to change their format to "tight," 3) resize all of these pictures to Height: 2.00 inches and width: 2.70833333333333 inches, 4) place eight of these pictures in 4 rows and 2 columns next to one another, 5) add a bolded dark line between each picture to differentiate the pictures, and 6) add a text box to the bottom of each of these panels with a black background (each individual picture, 8 text boxes per sheet).

    If someone could figure out how to do this with a click of a button, it would be a huge time saver! Again, please see the image below for an example of how I would like this to look!

    Thank you!!

    Example Image.jpg


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-10-2023 at 01:37 PM.

Similar Threads

  1. Did You Know :: Format Comment Box Using Shapes
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-16-2013, 10:50 PM
  2. Macro To Insert Columns In Excel
    By jac3130 in forum Excel Help
    Replies: 2
    Last Post: 05-17-2013, 07:49 AM
  3. Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  4. Set Adjust A Button Top Left Position Programmatically
    By jeffrey159 in forum Access Help
    Replies: 5
    Last Post: 02-02-2013, 06:24 PM
  5. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •