Hi Madiya

VB6 does not recognize Excel things unless you set reference to the Excel
object library. This is done in the Project References menu.

HTH. Best wishes Harald


"Madiya" skrev i melding
...
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