Search:

Thanks ,that fixed it :)

My SQL statement only retrieves one record and is pasted into the correct cell when this runs


ActiveCell.CopyFromRecordset (objmyrecordset)

Sometimes nothing is...

This now gives a 3707 error, Cannot change the ActiveConnection property of a recordset object which has a command object as its source"

Hello

I have an excel sheet where the user enters a bunch of parts numbers then a script matches each number
in turn and returns another value from a SQL connection.

This works fine the first...