Find Jobs
Hire Freelancers

Application Tracker(repost)

$100-250 USD

Abgesagt
Veröffentlicht vor fast 14 Jahren

$100-250 USD

Bezahlt bei Lieferung
A Microsoft Excel 2003 plugin must be developed that will allow the user to traverse a text file and update the STATUS field of the active worksheet based on information from the text file.? ? The active worksheet will first be read into a DataGridView. This is a Windows XP forms project that must be developed using Visual [login to view URL] 2008. *** DO NOT USE VSTO OR ANY THIRD PARTY TOOLS.? ADD-IN EXPRESS FOR OFFICE AND .NET MAY BE USED, BUT PLEASE INDICATE THIS IN YOUR BID. *** *** YOU MUST INDICATE HOW LONG YOU ESTIMATE IT WILL TAKE TO COMPLETE THIS PROJECT.? THIS WILL BE A MAJOR FACTOR IN DECIDING ON A BIDDER. *** ## Deliverables This project calls for a VB.Net addin for Excel to be created, and added to the Main Menu bar. The user should be able to update the status of applications by selecting the menu item called "Update Application Status", which will cause the program to traverse a text file to get the status of the application and update the STATUS column of the worksheet. The attached file named [login to view URL] includes the necessary Excel worksheet and sample project showing the data already loaded into the DataGridView. The following functionality should be added to complete this project: 1. Check to see if a column named "STATUS" exists in the active worksheet. If not, prompt the user to ask if the column can be created. If the user chooses "No", then exit since the STATUS column can't be updated if it does not exist. 2. Read the entire active worksheet into a DataGridView, then display the dataview form to the user. 3. Add filtering capability. The user will not be able to edit records in the DataGridView, but will be able to filter records on any column. Make sure that any records filtered in the DataGridView must also be filtered in the open worksheet. 4. This project will use a proprietary system to get application status information. However, for the purpose of this project testing, the included text file named "[login to view URL]" must be read to get the application status based on the "AU Id" field. For each AU Id in the Excel worksheet, get the status from the text file and enter it into the STATUS columns of the DataGridView and the worksheet. 5. Change the font color to green the entire row of each application whose status is "COMPLETED", and red for the entire row of each application whose status is "INCOMPLETE". 6. The data form must appear on top of the open worksheet, and the user should not be able to edit the worksheet while the form is visible. But, the user should be able to switch to other applications if needed. 7. Complete the status bar and progress bar to be updated appropriately.
Projekt-ID: 3441414

Über das Projekt

Remote Projekt
Aktiv vor 14 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

Über den Kunden

Flagge von UNITED STATES
United States
5,0
21
Mitglied seit Sept. 8, 2001

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.