Excel CopyFromRecordset Resets Filter
Nicolas Galler | September 18, 2007Well I had some suspicions that might happen when I noticed it reset the sort order. But yes, Excel also resets the recordset’s filter. Now I have to decide which is faster – copying the recordset beforehand, or editing the Excel data after it is copied… Anyway, figured that might be useful to someone else and spare them the whole head wall banging thing.





