We have a report that pulls to Excel from a SQL database using 2 different queries to populate data in the workbook. ? 1. We would like to have one button for employees to push to update the data from both queries.
2. We would like to hide worksheets that contain calculations and other data that we do not want our employees to see. ? There is only 1 worksheet that employees need to see.
3. The application will need to pull data over the internet as many employees work from home. ? So users will need to enter a username/pw.
This project can be accomplished in many ways (VBA, stand alone app using .Net, etc.). ? Please let us know what method you think would work best when submitting your bid.