I am creating a Query Table to SQL Table in Excel 2003. If server name, password or user id is incorrect, Excel pops a form so that correction can be made.

Unlike shown below, I use a user form to first capture the info (server name, password, user name, table, sub table); then, I refer to the items in the applicable arrays.

This is for creating a mapping table for use with Web Services... which obviously needs the CORRECT info.
But when the user has entered incorrect info, and then Excel pops its form so that user can correct the info, I need a way to capture the corrected info... else the mapping data will remain incorrect.

Can't figure out how to do that. Any help would really be appreciated!
-Ernie

Please Login or Register  to view this content.