vba function needed
workbook name : C:\Program Files\MyWork\MyResults.xls
I have about 15 queries to append to a worksheet("ResultData")
All with various Names:
Export Status Codes
Export Red Codes
Export Resgualr Codes
But these names I could put in a text file
to loop through?
I need a VBA routine to append each query and its field headers to append to each other.