I'm looking for a Microsoft Excel and Visual Basic.
To avoid revealing all our Data to all users and to avoid to implement a web page with Database, we just want to have a excel file on a share, which each user will look into it for querying their relevant information.
For initiating the Query, a UI within Excel will be needed. The main point here is to restrict direct access to data from excel sheets to users. Access can be password protected.
Here a task list:
- Provide a UI within the Excel table to start the query from
- Query should run over all Sheets within Excel
- Data will be entered by me
- Data access should be password protected
- This should also run under Excel 2016
39 freelancers are bidding on average $158 for this job
Hi, I'll code your Excel 2016 UI using sql, ado, vba providing a task list. If u need it via Ms Access split DB( Access fe and be over LAN for max 20 users) - I'm ready for that also
I am confident that I can help you surely because i have good experience with this kind of project development before. I can start immediately. Let's discuss in detail Looking forward to hear from you
Please review my profile as i am an expert in Excel and VBA. I can help you with this project as i have done the same in the past. Thanks, Asad Khan
hi, I am a senior visual basic .net developer, I can build a Excel addin with forms to process the query data, and then show data results in the current workshet