Excel Add-In to Connect Workbook UI to Database

I am building an Excel application. Essentially, this application is designed to allow user collaboration by entering data through the spreadsheet into a SQL Server database and then also update data in the spreadsheet from the database, allow the user to mainpulate it, and then push the edits back into the database.

This application will use an Excel-based user interface I have already created to enter data into (and then pull data from) and a SQL Server database that I have already created in SQL Server Express. I have however gotten in a time crunch and need help building an Excel Add-In that essentially has all of the VBA code to "connect" the Excel UI I have developed with the database I have built and provides all of the necessary features. This Add-In will need to contain the VBA code necessary to enter the data entered in the spreadsheet (there are a total of 9 database tables that data will be entered into). Also it must then be able to update the data in Excel from the database, allow the user to make edits to it, and then commit the edits back to the database.

I think this should be relatively straight-forward to accomplish for someone who is good with VBA and has a lot of experience with programming in Excel. There are a total of about 15 worksheets in two Excel workbooks that are setup to enter data into report data from the database. I am pretty desperate as I need to have this ASAP but am working to do it on my own in the meantime. The attached workbook shows the user interface I want to work with which should make it very clear what I am trying to accomplish with Excel Add-In. Only needs to be compatible with Excel 2007 and SQL Server 2005, no backward compatibility/testing required.

Taidot: .NET, Excel, SQL, Visual Basic

Näytä lisää: entering data excel, excel sql server, full source code hospital management system, what is vba programming, what is database programming, what is an interface in programming, what is an application programming interface, visual basic programming 2005, visual basic in programming, vba programming in excel, vba excel programming, ui programming, sql programming in vba for excel, programming in visual basic, programming in vba, programming in sql, programming in net, programming in excel vba, programming in excel, programming in basic, programming for excel, programming database, need help with visual basic programming, need desperate help with c programming, excel to application

Tietoa työnantajasta:
( 5 arvostelua ) Westminster, United States

Projektin tunnus: #472726

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi Good day, Expert in Excel addin development. Please check PM. Ready to start the work. Regards [login to view URL] B.E

$250 USD 1 päivässä
(26 arvostelua)

Kindly see PM for details. Vlad

$699 USD 3 päivässä
(13 arvostelua)

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

$550 USD 10 päivässä
(6 arvostelua)

Hi, Please refer to your PMB Regards

$750 USD 9 päivässä
(0 arvostelua)

Send me the database schema and I will add the VBA code behind the buttons which is integrated with the Excel Addin. So, all you need to add to this button code is simply table name and worksheet name such as following Lisää

$425 USD 0 päivässä
(1 arvostelu)

Your project is very easy. I am working in the software developing for 10+ years. I am confident in your project. I will do my best for you.Thanks. Please see my PMB.

$300 USD 5 päivässä
(0 arvostelua)