sql select statement in vba not pulling headers from excel closed workbook and some other values
I am working with excel workbook to pull data of my closed workbook “RawData.xlsm” sheet name “all_register”. following are the code, but this vba code unable to pull all headers (first rows/ columns names) as well as some cells values (value cell format is “General”
Excel VBA ADODB connection with parameters error: The variable name ‘@…’ has already been declared
The variable name ‘@P10’ has already been declared. Variable names must be unique within a query batch or stored procedure.