Hello all,
I keep getting the following error whenever i execute my script. The script is supposed to retrieve data from the source database and then replace from one excel spreadsheet to a formatted sheet. Can anyone assist.
Application-defined or object-defined error
Workbooks(nn).Sheets(1).QueryTables(1).Refresh