ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MS Query parameter (https://www.excelbanter.com/excel-programming/404140-ms-query-parameter.html)

Souris

MS Query parameter
 
Does MS query accept to pass parameter?

If yes, how can I pass them?

Your infromation is great appreciated,

FSt1

MS Query parameter
 
yes it does.
Right click in the query data, click edit query.
when the query wizard comes up, click to the last screen and check...
view data or edit query in microsoft query. click finish.
when the MSQ dialog comes up, on the menu bar click criteriaadd criteria.
you can enter your parameters here.

Regards
FSt1

"Souris" wrote:

Does MS query accept to pass parameter?

If yes, how can I pass them?

Your infromation is great appreciated,



All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com