Käynnissä

Excel VBA Conversion To .Net

We have an Excel Spreadsheet that has VBA programming in it. It is a data validator and formatter. It launches with a form, and prompts you to choose what type of data file validation and conversion.

1. NextGen to FoxPro

2. OpenDBF

3. Convert Affinity Txt Files To XLS

Once you select an above choice,

1. Asks you to load 3 files.

2. Asks you to locate a .DBF file

3. Expects 3 files to already be placed in a location on the C drive.

On a per-provider / site basis each iteration.

The result of either operation spits out 3 files.

We want this Excel spreadsheet to be converted to a .Net v2 compliant application that can be run from the command line as well as from a windows application as it sits now.

We also want it to be parameter customizable with inputs for example from command line:

1. Type of conversion (1, 2, or 3 above)

2. File 1 and path

3. File 2 and path

4. File 3 and path (each file dependent or not required based on which converstion and validation type you want)

5. Output folder (creates if does not exist an enumerates new folder if exists)

The worksheets in the spreadsheet contain reference data. We want to be able to add, edit, delete, etc., via SQL tables and Web Browser, and store the old value in another table like it, with a field "changed MMDDYYYY by WINDOWSUSERNAME. Any value that is presently hard-coded into the VBA will need to be configurable from the new app.

As well as from the app, able to control what server, database that the reference data is stored in

We will provide a copy of this spreadsheet - once cleared through management, as well as sample data with which to test.

The VB used for these processes already exists. We know it is a small manual effort retrofitting code to run in a .Net project.

Successful delivery will consist of:

[url removed, login to view] Source Code - so that we can test and compile it, and rebuild/publish it as needed successfully.

SQL for creating the tables.

A successful test of the process, and the resulting data must mimic ours 100%.

Follows business rules and best practices for [url removed, login to view] development, including form/data validation, etc.

Offline NDA will be provided. We choose fixed price, due to budgetary constraints.

No upselling and no additional / special purpose apps will be purchased by us; we presently can run [url removed, login to view] v2 apps and SQL 2005.

Please - if you are not confident you can develop this and it works without fail on first delivery, please do not bid on this project.

Taidot: .NET, Excel, SQL, Visual Basic, Visual Basic for Apps

Näytä lisää: excel vba form sample, excel vba validation project, works need excel, net used, need develop app, visual foxpro web application, visual foxpro web, visual foxpro source code, visual foxpro price, visual basic programming 2005, net project management, vba load, vba excel programming, test iteration, sql programming vba excel, sql data conversion, source visual foxpro, sample nda form, publish xls web, programming visual foxpro, programming vba, programming foxpro, programming excel vba, programming excel 2013, programming best practices

About the Employer:
( 8 reviews ) Wilkes-Barre, United States

Projektin tunnus: #4270324

Myönnetty käyttäjälle:

diegogarcia0531

Hi, I can do the job, VB.NET expert, VBA, VB6, Software developer for several years I am looking forward to work with you Best Regards Diego

500 $ USD 10 päivässä
(18 arvostelua)
4.7

12 freelanceria on tarjonnut keskimäärin 475 $ tähän työhön

shawnburt

Sounds like it should be a fairly easy project. To clarify I have a few questions. 1. What version of FoxPro? I will sometimes affect which connection method I use. 2. Do you want a GUI program and a CmdLine program Lisää

700 $ USD 10 päivässä
(101 arvostelua)
6.4
ZeusMan

Looking forward to working with you...

500 $ USD 4 päivässä
(58 arvostelua)
5.7
Kryptora

Hello, I am a .NET, VBA and VSTO software developer. I have nine years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfaction.

700 $ USD 10 päivässä
(45 arvostelua)
5.6
SICS

Hi, Please see the private message also. Regards

750 $ USD 15 päivässä
(8 arvostelua)
5.4
SmartGuru

Hello, I can migrate the application from Excel to .Net. Kindly check the private message for further information.

480 $ USD 10 päivässä
(29 arvostelua)
4.8
avenditti70

Hello. I'm an experienced developer with multiple Microsoft certifications (MCP, MCT, MCAD, MCSD, MCDBA). I own a deep experience on .NET development and Microsoft database systems. I'm also a writer contributor with Lisää

250 $ USD 10 päivässä
(4 arvostelua)
4.2
murtaza1981

Hi aaronMFHS , I (Myself a senior [url removed, login to view] programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robus Lisää

475 $ USD 12 päivässä
(8 arvostelua)
3.3
alliaunce

Will get back with demo app. Will be great if you could share the vb code/excel .

250 $ USD 3 päivässä
(6 arvostelua)
2.9
srdas2012

We can do it in [url removed, login to view] after we receive a Reply from You

300 $ USD 15 päivässä
(6 arvostelua)
2.6
benefitworks

Hi Sir, This is interesting work, I developed many [url removed, login to view] apps that interact with excel sheets, powerpoints etc. For more details please see my PM. Thank you Karim

600 $ USD 14 päivässä
(3 arvostelua)
2.5
GT1002

I am interested

600 $ USD 20 päivässä
(1 arvostelu)
1.9
Locust

Hi, I can port it, please see your PMB for details. Thanks.

350 $ USD 20 päivässä
(3 arvostelua)
1.9