Show Bid Request
VBA Macro
Bid Request Id: 12132
|
|
|
|
Posted by: |
jebock (3 ratings)
(Software buyer rating 10)
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Mar 29, 2002
12:47:18 PM EDT
|
|
Bidding Closes: |
Apr 12, 2002
1:01:11 PM EDT
|
|
Viewed (by coders): |
419 times
|
|
Deadline: |
4/22/2002 11:00:00 AM
TIME EXPIRED
|
|
|
|
|
Description:
Help!
I need a VBA macro for word that will do the following to the attached word doc.
- Make entire document 2 column
- Remove the text "Hours:"
- replace text "After" with "After Hours:"
- After each doctor's listing, add a 1 point rule across the column and add a single blank line of space.
- Ensure that no doctor's listing is split over columns or pages (In other words, if Dr. Jones starts at the bottom of column 1, his entire listing is still on column 1...he doesn't end up with his name on column 1 and his addres at the top of column 2). There should be 5 docs in each column, 10 to a page.
Obviously, the full list is much longer (170 pages) and has a variable number of docs each month. All of the listings end with the:
"After (###)###-####
Hours:"
text although some doctor listings have more address lines, different amounts of info (so you can't count on there being a set number of lines to each listing).
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Complete copyrights to all work purchased.
Platform:
Windows 95/98/2k
Word 2k
Must be 100% finished and received by buyer on:
Apr 22, 2002 11:00:00 AM EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$30 (USD)
|
Mar 31, 2002
9:58:01 AM EDT
|
10
(Excellent)
|
|
|
Dear Jebock
File attached (AfterMacro.zip) of the word document after the VBA macro has been run (Macro removed of course).
Please let me know of any changes you require to the look of the finished document and I will place a revised bid.
Alternativelly accept the bid and I will forward the macro to you upon confirmation.
Regards
MikeB1972 |
|
|
Attached File
|
|
|
|
|
|