Create excel & Text file based on filter data save to a specific location

  • Hi, this is a solved post but I need some attention.

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Use a Command Button to Create a User Defined Worksheet With Specific Data

    I am using the code which is created by "KjBox" given below.

    In this code, the file created a new worksheet for all the data of Header "Invoice", If I filter the" invoice" then it also generates a file with all data of Header "Invoice"

    I want it will only generate a excel and text file based on the filter or visible data only of the Header "Invoice"

    Hope someone helps me.

    Thanks in advance.