Hi,
Can anyone tell me why ActiveSheet.PivotTableWizard asks for a DSN connection?
ConnectString = "ODBC; Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=" & gs_path & "; Extensions=asc,csv,tab,txt; UID=admin;"
QArray = Array(ConnectString, "Select * From " & lv_src)...