PC Review

Thread Tools Rate Thread

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

New Member
Join Date: Sep 2011
Posts: 1
      18th Sep 2011
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
File Type: pdf Group.pdf (6.4 KB, 111 views)
File Type: pdf Group2.pdf (20.0 KB, 83 views)
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge existing PDf file in the same folder to one PDF file =?Utf-8?B?Q0xD?= Microsoft VB .NET 2 26th Sep 2007 06:12 AM
Convert Reports & Snapshot to PDF - No PDF Printer driver required =?Utf-8?B?TWljaGFlbA==?= Microsoft Access Reports 0 1st Sep 2007 12:04 AM
Unable to Insert cut cells, or Insert move cells down Ramesh Microsoft Excel Discussion 5 21st May 2007 12:24 PM
Insert Merge Field problem with Word-Mail Merge from Excel documen =?Utf-8?B?QXVndXN0YSBFLg==?= Microsoft Word Document Management 2 20th Jun 2005 10:59 AM
BUG: Script blocking strips script parameters during script authorization Jonathan K. Shay Spyware Announcements 3 2nd May 2005 06:18 PM




All times are GMT +1. The time now is 04:24 AM.