Export Excel Worksheet to File (with Macro)

  • Hi everybody!

    I need to export an excel worksheet (just some rows and special cells) to an file with the extention .exs. It should be exported nomally like exporting to a textfile, so that I am able to read it with tools like UltraEdit.

    How do I write such a macro, exporting things to a file?

    Thx in Advance!

  • Here is how i accomplish your requested task:
    NOTE: You may have to add a reference to Microsoft scripting Runtime in your VBA Editor (Tools > References)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!