# Filter removal operations in Excel with VBA

**URL:** <https://forum.robusta.ai/t/filter-removal-operations-in-excel-with-vba/114>\
**Category:** FAQ\
**Created:** [May 9, 2022, 11:12am UTC](https://forum.robusta.ai/t/filter-removal-operations-in-excel-with-vba/114 "2022-05-09T11:12:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilayda.ipar](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robusta.ai/ilayda.ipar/32/56_2.png) [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\
**Post date:** [May 9, 2022, 11:12am UTC](https://forum.robusta.ai/t/filter-removal-operations-in-excel-with-vba/114/1 "2022-05-09T11:12:31Z")

</div>

All filters in excel can be removed with the following VBS.

⬇

```auto
Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = False
objXLApp.DisplayAlerts = False
Set objXLWb = objXLApp.Workbooks.Open("C:\Robusta\Excel Folder\2021_07_Tapdk.xlsx")
objXLWb.Worksheets(1).AutoFilterMode = False
objXLWb.Save
objXLWb.Close
objXLApp.Quit

```