Find Jobs
Hire Freelancers

VBA expert needed

₹600-1500 INR

Chiuso
Pubblicato più di 5 anni fa

₹600-1500 INR

Pagato al completamento
1 – Read a file of existing employee IDs 2 – Accept data entry from a user 3 – Write the data to a CSV file Details 1– Read the file of valid employee IDs. Assume the file could be up to 100 IDs. Store the valid IDs in an array. 2– Accept employee data input from the user in the order below and at a minimum perform the listed validations. Field Employee ID Last name First name Hourly pay Validation 5 characters, first character must be ‘A’, then a 4-digit number. 2 – 15 characters, no numbers 1 – 15 characters, no numbers a numeric value > 5 and < 100. Accept dollars and cents. If the user entered ID is not found in the existing IDs array, ask the user if they want to enter a new employee. If they answer yes, continue, otherwise go back to entering another ID. After all four fields have been collected with valid input, show the user a summary of the data and ask if they want to save it. If they answer yes, append the data to the file. If they answer no, confirm they want to delete that data. In both cases, go back to entering another ID. Data entry validations should give user-friendly error messages and allow the user to retry. 3 – Write the data to a file titled [login to view URL], with a header row and then a row for each employee. Each field should be separated by a comma ( , ) including the header row. For the hourly pay, save the data with two decimal places. Deliverables: For each program submit: ➢ Program analysis ➢ Hierarchy chart ➢ A working VBA programs with good internal documentation.
Rif. progetto: 18285780

Info sul progetto

3 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
3 freelance hanno fatto un'offerta media di ₹3.796 INR
Avatar dell'utente
I am a Data Entry Expert and proofreading with 15 years of experience. I also have experience in word, PowerPoint and excel. PDF to Word and Excel. My motive is to make my employer Happy without additional charges and time, so please, give a chance please.
₹5.611 INR in 1 giorno
4,6 (67 valutazioni)
5,1
5,1
Avatar dell'utente
Hello. First, your project is not really difficult to do, but becasue you have a lot of conditions, it will take a lot of time to write all of the VBA code. So I think you do not have many bidders becasue the price you offer is too low. But I am ready to do it for 3000 rupees, even though that is still a low amount. I read the proposals from the other bidders, and it looks to me like they did not even have the courtesy to write you a personal bid, but just did copy-paste of the same text that they use on every bid.
₹3.000 INR in 3 giorni
5,0 (1 valutazione)
1,6
1,6

Info sul cliente

Bandiera: INDIA
Moradabad, India
5,0
24
Metodo di pagamento verificato
Membro dal feb 10, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.