Export or email excel worksheet

I'm trying to write a Macro so that I can use a command button to automatically export a range of cells from a variety of sheets in a workbook. I pretty much know how to select the ranges and everything. But I need some help with exporting the information to a totally separate workbook, or emailing the information. I want to use a command button (which I know how to set up) so that my students can click on the button to run the macro that will do this.

If someone could help I would appreciate it.

(I have Excel 2003)

2 replies


You can use these use full SEO tools

1.) oN pAGE eMAIL eXTRACTOR http://tools.computer-ustad.com/on-page-email-extractor.php
2.) tITLE aND dESCRIPTION eXTRACTOR http://tools.computer-ustad.com/title-and-description-extractor.php
3.) fREE rECIPROCAL lINK cHECKER http://tools.computer-ustad.com/reciprocal-link-checker.php
4.) hOME pAGE mAKER http://tools.computer-ustad.com/home-page-maker.php
5.) uNIQUE aND dUPLICATE hUNTER http://tools.computer-ustad.com/unique-and-duplicate-hunter.php
6.) uNIQUE aND dUPLICATE hUNTER oN dOMAIN http://tools.computer-ustad.com/unique-and-duplicate-hunter-on-domain.php
7.) gOOGLE pAGE rANK cHECKER http://tools.computer-ustad.com/page-rank-checker.php
8.) iNTERNAL pAGE rANK cHECKER http://tools.computer-ustad.com/internal-page-rank-checker.php
9.) iNTERNAL eXTERNAL lINK cHECKER http://tools.computer-ustad.com/internal-external-link-extractor.php

Thank you for the great tools.


You can use these free SEO tools, below is the updated versions of tools

* bULK rECIPROCAL lINKs cHECKER http://tools.computer-ustad.com/bulk-reciprocal-links-checker.html
* cONTACT & lINK pAGE eXTRACTOR http://tools.computer-ustad.com/contact-link-page-extractor.html
* eMAIL eXTRACTOR http://tools.computer-ustad.com/email-extractor.html
* gOOGLE cACHED cHECKER http://tools.computer-ustad.com/google-cached-checker.html
* gOOGLE sAFE bROWSING dIAGNOSTIC pAGE http://tools.computer-ustad.com/google-safe-browsing-diagnostic-page.html
* gOOGLE, yAHOO aND mSN wEB dATA eXTRACTOR http://tools.computer-ustad.com/google-yahoo-and-msn-web-data-extractor.html
* hOME pAGE mAKER http://tools.computer-ustad.com/home-page-maker.html
* iNTERNAL eXTERNAL lINK eXTRACTOR http://tools.computer-ustad.com/internal-external-link-extractor.html
* iNTERNAL pAGE rANK cHECKER http://tools.computer-ustad.com/internal-page-rank-checker.html
* pAGE rANK cHECKER http://tools.computer-ustad.com/page-rank-checker.html
* rECIPROCAL lINK cHECKER http://tools.computer-ustad.com/reciprocal-link-checker.html
* tITLE aND dESCRIPTION eXTRACTOR http://tools.computer-ustad.com/title-and-description-extractor.html
* tITLE, dESCRIPTION & eMAIL eXTRACTOR http://tools.computer-ustad.com/title-description-email-extractor.html
* uNIQUE aND dUPLICATE fINDER http://tools.computer-ustad.com/unique-and-duplicate-finder.html
* uNIQUE aND dUPLICATE fINDER bASED oN dOMAIN http://tools.computer-ustad.com/unique-and-duplicate-finder-based-on-domain.html