Excel macro to email single worksheet as an attached file
This macro adds a menu option to the Tools menu, which creates a copy of the active worksheet as a new workbook file and allows you to email individual sheets as attachments.
About Me
If you need Excel-based automation I'd love to help you out. I'm an Excel superuser with over 4 years of experience working with Excel VBA and 6 years experience in research & analytics for a leading market research company. As a graphics programmer I specialize in using VBA in Excel to automate: * Dynamic reporting tools like "dashboard" chart views * Ad hoc macros to simplify often-repeated tasks * Manipulating and parsing string data (XML, HTML, etc.) * Development of GUI/User Forms to accept user inputs to drive macros, etc. * Customized deliverables like charts and data tables\ * Data and text sorting, manipulation, transposition, transfer, etc. I strive to understand the project-specific requirements, and deliver thoroughly tested macros and automated workbooks to make routine/repeated tasks easy.
