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

Discussion in 'Webmaster / Programming' started by timepass111, Sep 18, 2011.

  1. timepass111

    timepass111

    Joined:
    Sep 18, 2011
    Messages:
    1
    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

    No value given for one or more required parameters

    Dryden, Sep 19, 2005, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    5,685
    Dryden
    Sep 19, 2005
  2. aztec_bikes

    help required, website forms

    aztec_bikes, Oct 17, 2005, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    776
    ukJAG
    Oct 17, 2005
  3. vignesh_n

    VBA Help Required for Charts

    vignesh_n, Jul 30, 2006, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    809
    vignesh_n
    Jul 30, 2006
  4. spartan360

    Looking to learn, advise required

    spartan360, Jan 7, 2008, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    815
    feckit
    Jan 8, 2008
  5. rosa.jen

    Excel Save and attach pdf to Outlook Email

    rosa.jen, Aug 10, 2011, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    1,406
    rosa.jen
    Aug 10, 2011
Loading...

Share This Page