Thanks RobDog, so would my example query work or would it need to be re-written?
VB Code:
SELECT * FROM WorkSheetName Range A1 to A1000
Also, if the spreadsheet was already open would it be a problem when connecting to it? If so, is there a way around it since it will be open when I want to run the query?




Reply With Quote