Select Autofilter then copy paste

[nicolaforni]

Hi,

Starting from a workbook BookData.xls I need to go into a s/s in workbook BookFilter.xls (see attached) select the autofilter (called Datemonth), select a date then copy data and paste it into workbook BookData.xls in Sheet1.

I have the code below:

Please Login or Register  to view this content.

This is what is really strange.
If the criteria in autofilter is a text example A or B the macro works but If the criteria in autofilter is a date eg. 04-Sep-12 then it does not work.
Any idea why this is the case and what I should do to make the Macro work?


Thanks,
Nix

[HaHoBe]

Hi, nicolaforni,

convert the Date to a long:

Please Login or Register  to view this content.

The other workbook needs to be opened in the same instance, try it like this:

Please Login or Register  to view this content.

Ciao,
Holger