Hello,
I record a New Database Query inside excel, and record macro that runs the
query as below. How can I run the Sql Command text without running Open File
*.dbq ?

Workbooks.OpenDatabase Filename:= _
"G:\Help.dqy", CommandText:=Array( _
"SELECT `ADC_Parts$`.Mfg, `ADC_Parts$`.`Part Number` FROM `G:\ADC
Parts`.`ADC_Parts$` `ADC_Parts$` WHERE (`ADC_Parts$`.Mfg='ACC') ORDER BY
`ADC_Parts$`.`Part Number`" _
), CommandType:=xlCmdSql
--
Thanks & Best Regards