Excel 2007 Automation Project (807024)

**Scope of Work**:

***Insert pages in Report***:

Develop an execution call to automate this process:

1. Unprotect the destination worksheet (password-masters).

2. Copy the source cells from the template worksheet.

3. Paste the copied cells onto the next blank page.

4. Protect the destination worksheet (password-masters).

There are three (3) different template worksheets used with three (3) related sections so the execution call may prompt for the section to be copied or there may be three separate automations.

***Delete pages in Report***:

Develop an execution call to automate this process:

1. Unprotect the destination worksheet (password masters).

2. Select an existing picture and delete it.

3. Select all cells on the page to be removed.

4. Delete all text and formulas in the selection. “CUT?? cannot be used due to effect on formulas that reference these cells.

5. Remove all formatting.

6. Select information cells at bottom of last good page and apply the appropriate border setting to match the rest of the cells.

7. Protect the destination worksheet (password-masters).

These execution calls MUST be simple and accomplished easily. This will be used in an outdoor environment where the user may have gloves on and will be using a tablet system with a stylus and an on-screen keyboard. It will be executed multiple times during a construction inspection.

I must be able to copy these execution calls and method to invoke them into existing workbooks that are based on this template workbook.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Will be used on Windows XP Pro in MS Office Excel 2007.

Lập trình C Perl PHP

ID dự án: #3469483

Về dự án