Troubleshooting syntax error

Hi. I am trying to import from an SQL database that I have limited access to. It's a replicated database and we are allowed to take data from it and put into excel to manipulate or research etc.

The error is:

Screenshot 2021-05-14 161939.png

The last line above is what is highlighted by the debugger. Hovering the cursor over the first part will popup the line. I've attached screenshots of the error and the debug clue.

Screenshot 2021-05-14 162136.pngThen it continues.

I'm not a programmer but I'm ok at learning and reading and adapting. I don't see any obvious errors. I know the sql will run without the VBA modifications on the companies sql server. I know all the calls and such work.

I tried pasting the code in between the code and /code bracket tags and on previewing it said I was blocked for an sql injection. If someone can tell me what I did wrong i will be happy to post the code for review.

Per the documentation, the 1st positional argument to ADODB.Recordset.Open must be 'A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persistently stored Recordset.' "WO.RESOLUTIONDATE desc" isn't a valid SQL statement, a valid table name, or a URL, nor I figure is it the valid name of a file or stream object containing . . . That leaves the possibility it's a stored procedure call with the parameter desc. You don't show enough code for me to tell what it's supposed to be.

I've no idea why the board will not allow me to post the code. Like I said, I had it pasted in the code tags but it still blocked me. I will look at the code again on Monday. But I bet there is an order by statement and I might have truncd the line. DESC is short for decending. That's what makes me bet that way. Thanks for the pointer.