I use Excel to give users access to data all the time without having to use VB code. Instead of using Stored Procedures you can use Views and then...

I have created many queries using Excel as my tool. Instead of stored procedures I use Views because they allow parameters. create a view in SQL and in the...