Show Bid Request
Small College Program Assignment in Excel and Visual basic 6
Bid Request Id: 5361
|
|
|
|
Posted by: |
MikeH (2 ratings)
(Software buyer rating 9.5 )
|
|
Non-action Ratio: |
Above Average - 28.57%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Nov 23, 2001
4:17:33 PM EDT
|
|
Bidding Closes: |
Dec 7, 2001
4:18:56 PM EDT
|
|
Viewed (by coders): |
546 times
|
|
|
|
|
Description:
Here is the Assignment:(OLE)
A macro is required which puts zeros into all the columns other than the Teams column of the Excel spreadsheet table(spreadsheet is attached).A VB program is required to input a match result and update the table. It should have a command button
Update Table
and text box controls for the home team, goals scored by the home team, away team and goals scored by the away team. The Update Table command button, when clicked, should update all columns (including goals scored and conceded) of the Excel spreadsheet table using OLE automation objects and display the Excel table of the teams in alphabetical order in an OLE control.
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.
Special Conditions / Other:
I have to hand in this assisnment by 3/12/01
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 |
|
|
|
|
$15 (USD)
|
Nov 24, 2001
6:08:42 PM EDT
|
9.66
(Excellent)
|
|
|
Hi,
I am very fluent with both VB and OLE automation and am very excited by the prospects that your bid offers.
I would love the opportunity to serve you. I am certain that I will be able to complete your requirements in as little as 3 days after the acceptance of the bid.
I await your response,
Sincerely
Shmarya
Microsoft Certified Solutions Developer |
|
|
|
|
|
|
N/A
|
Nov 25, 2001
6:05:08 AM EDT
|
9.66
(Excellent)
|
|
|
I have completed the work and attached it here. I have used the application References to do most of the work. Please do not forget to accept my bid and pay me should you download the Attachment. It will have been a pleasure working with you. If you have any problems do not hesitate to ask me.
Sincerely,
Shmarya
Microsoft Certified Solutions Developer |
|
|
Attached File
|
|
|
|
|
|
N/A
|
Nov 26, 2001
8:52:38 AM EDT
|
9.66
(Excellent)
|
|
|
Hi,
I do not see the problem with the project. What is it that you are trying to do exactly?
To see the code for the Macro (SetToZeros) just open the excel spreadsheet normally, click on Tools|Macro|Visual Basic Editor and change to the modCodes Module. You should find the routine there.
To view the code for the Match Entry program, just open the Visual Basic project.
Please do not hesitate to message me should there be any further problems.
As always a pleasure to be of assistance!
Sincerely,
Shmarya
Microsoft Certified Solutions Developer |
|
|
|
|
|
|
Shmarya