I'm developing an Excel workbook that retrieves data from an Access 2000 database. The database query is embedded in the workbook and uses cell references as parameters. The cell references point to cells that are linked to VB form tools such as combo lists etc.
I am trying to send a wildcard (asterisk) through to the query as a parameter but I get the following clumsy message:
"Bad parameter. Microsoft Excel is expecting a different kind of value than what was provided."
Could anyone tell me how to include wildcards in this type of query? Or is there a way to exclude the use of certain parameters when they are not required?