Application-defined or object-defined error

[ewarts]

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).S heets(1).QueryT ables(1).Refres h