Excel VB Script Required to Insert PDF objects, Merge Cells and Format

Discussion in 'Coding' started by timepass111, Sep 18, 2011.

  1. timepass111

    timepass111

    Joined:
    Sep 18, 2011
    Likes Received:
    0
    hello everyone,

    I am a complete noob when it comes to Microsoft Excel and wanted help to perform the following function:

    Step 1:

    the preliminary data looks something like the file attached in the thread "Group.pdf" :

    Step 2:

    the output file looks something like the file attached in the thread "Group2.pdf"

    The basic requirements for creating the output is:

    1. Minimum height of alternate cells of Column D must be 75 (100 pixels)

    2. If a group has more than 1 and less than 6 data entries (data 1, data 2 etc.), the corresponding cells of Column B and Column D should be merged and centered and also the row height must be split evenly to make the total as approx 75 (100 pixels) for a group. eg. in case of 2 data objects, row height for Row 4 and 5 are 37.5 each, for 4 objs, it is 18.75 each.

    3. The PDFs have to be inserted from a hard disk location without any user itervention. The PDFs will be stored as "PDF1.pdf", "PDF2.pdf" and so on for each corresponding group.

    4. By default when we insert a pdf, it gets inserted in the top left corner of that particular cell. In this case the PDF should be in the center like how the text "Group1" etc. are placed.


    Any help regarding this above problem would mean the world to me....

    even if there are partial solutions to solve some of these steps, please let me know...

    thanks to all in advance...
     

    Attached Files:

    timepass111, Sep 18, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dryden
    Replies:
    0
    Views:
    5,882
    Dryden
    Sep 19, 2005
  2. aztec_bikes

    help required, website forms

    aztec_bikes, Oct 17, 2005, in forum: Coding
    Replies:
    1
    Views:
    894
    ukJAG
    Oct 17, 2005
  3. vignesh_n

    VBA Help Required for Charts

    vignesh_n, Jul 30, 2006, in forum: Coding
    Replies:
    0
    Views:
    944
    vignesh_n
    Jul 30, 2006
  4. spartan360

    Looking to learn, advise required

    spartan360, Jan 7, 2008, in forum: Coding
    Replies:
    1
    Views:
    968
    Anon_F
    Jan 8, 2008
  5. pianomanjay
    Replies:
    0
    Views:
    1,228
    pianomanjay
    Apr 29, 2010
  6. rosa.jen
    Replies:
    0
    Views:
    1,586
    rosa.jen
    Aug 10, 2011
  7. pompeymick
    Replies:
    7
    Views:
    1,023
    pompeymick
    Mar 21, 2012
  8. ciberius
    Replies:
    0
    Views:
    732
    ciberius
    May 26, 2012
Loading...