Passing VBA Variables to a Web Query

[agwright]

Hi everyone,

I have username and password data that need to be sent to a web query, but for security reasons, I don't want either one to appear on the spreadsheet. To get around this, I made a UserForm that runs when the workbook opens to get the data into VBA variables, but I don't know how to then pass this data to a query. The query goes to a PHP SOAP client that requires authentication, so I can't send requests without a username and password, and yet I don't want them to appear on the screen. What I want to know is if there is a way to either:

1) Refer to VBA variables in a query so that the data inside the variables gets sent.

2) Write a macro that builds and executes a dynamic query at runtime.

Thanks!