Check if Excel Spreadsheet has Autofilter on

stephen81

Registered User.
Local time
Today, 00:02
Joined
Nov 27, 2002
Messages
198
I'm using docmd.transferspreadsheet to import data from a spreadsheet into my database. I need to check that the spreadsheet being imported hasn't got an autofilter on it though, before it is imported. Is it possible to do this from access? I know in Excel it is possible to check using vba but I need to be able to check from within access. Any ideas?
 

Users who are viewing this thread

Back
Top Bottom