I have a working macro in VBA which I am now trying to re write in VB6 as an application.

I am getting error here.
With XLWBSR <<< This is my workbook
With .AutoFilter.Range <<< Getting Error

Error says Runtime error 438, Object doesn't supprot this property or method.

While it works perfectly in VBA, I thought it should work in VB6 also.

Pl help for any change required for vb6.

Regards,
Madiya