The 2nd link in my initial post is to an article that shows an easy way - with minimal VBA - to facilitate the use of user-set parameters with stored procedures.
I would note that, if the Excel file is saved after going through the steps in either of the 2 articles, then the Excel file is portable with its connectivity, and the ODC file that is created is actually not required.
( I take it as given the SSPI Integrated Security is used to control access. )
As noted, I have implemented this solution in several corporate environments.
Regards,
Leo