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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Dryden
    Replies:
    0
    Views:
    5,946
    Dryden
    Sep 19, 2005
  2. aztec_bikes

    help required, website forms

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

    VBA Help Required for Charts

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

    Looking to learn, advise required

    spartan360, Jan 7, 2008, in forum: Coding
    Replies:
    1
    Views:
    1,042
    Anon_F
    Jan 8, 2008
  5. pianomanjay
    Replies:
    0
    Views:
    1,314
    pianomanjay
    Apr 29, 2010
  6. rosa.jen
    Replies:
    0
    Views:
    1,696
    rosa.jen
    Aug 10, 2011
  7. pompeymick
    Replies:
    7
    Views:
    1,166
    pompeymick
    Mar 21, 2012
  8. ciberius
    Replies:
    0
    Views:
    788
    ciberius
    May 26, 2012
Loading...