I would like to have a user enter a parameter into a cell in a worksheet, then run a saved query on that worksheet that uses that (cell reference) parameter. Has anyone ever done this that could help me?
When trying to add fields to the "row area" I get this message after about the 5th field:
Microsoft Excel cannot make this change because there are too many row or column items.
Does anyone know what this error message means?
I'm receiving an error message that says:
Windows cannot find recycled.vxd. This program is needed for opening files of type 'Registration Entries'.
I am trying to install the ODBC driver ODBCNT\odbcnt.reg. I have done this at least 20 times on different PC's within our offices and never...
Does anyone know of a way to assign a parameter value, that the user is prompted to input, to a variable that is to be used multiple times in the query?
Does anyone know of a good reference source for Excel data queries??? Thanks
I am trying to get a query with 5 parameters to work in Excel. The query works correctly when I hard code the parameters, but as soon as I modify the query to prompt for parameters it duplicates the number of parameters. Instead of asking for the 5 parameters, it asks for 10. If I enter each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.