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
36 pekerja bebas membida secara purata $157 untuk pekerjaan ini
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
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