Advanced Filter by Macro does not work anymore under Excel 2007 - Help !

S

Sagace

Hi to all,

I've actually some problems with excel 2007

This macro :
----------------------------------------------------------------------------------------------------
Sub FiltreAvance()
Sheets("BDD").Range("A3:V25000").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A1:D3"), CopyToRange:=Range("A11:S11"),
Unique:= False
End Sub
----------------------------------------------------------------------------------------------------

launch by a button from the sheet "Filter" to display the result of the
filter on the sheet "DataBase" which works perfectly under Excel 2003 does
not works anymore under Excel 2007 !!!

I'd be thankful for any helt to solve this new mystery ...

:blush:))

Serge
 
R

Ron de Bruin

Hi Sagace

If you send me your file private I take a look at it this evening
 
S

Sagace

Hi againt Ron,

just a little word to inform you I have find the cause of the problem !

It's Julien who put me on the way while indicating to me he had the same
problem solved by changing décimal separator from comma to point ...

My problem due to the date format ... (in french format dd/mm/yyyy) - Excel
2007 vba only knows english format (i.e. mm/dd/yyyy) !!!

I've just now to change my code to solve this new problem !!!

anyway ... many thanks for your help effer !

Sincerely yours

Serge (Sagace)
 
R

Ron de Bruin

Hi Sagace

Yes you have the same problem when you use AutoFilter
Use always the US mm/dd/yyyy format in code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top