Delete macros in another macro
I e-mail a spreadsheet to obtain a wide range of user information. The file has many graphic objects, controls and macros controlling user action and responding. Following the user's response I have the data e-mailed back by macro, but do not need the macro's or any user interface anymore. The file is 660KB in size (with the macros). After deleting all graphic objects, text and formats, the file that gets e-mailed is still 490KB in size. There are ± 700 event handlers in the macros. These can all be deleted before e-mailing
Is there a way to address macro modules from another macro, specifically to delete them |
Delete macros in another macro
Hi John
See this webpage http://www.cpearson.com/excel/vbe.htm You can use my sendmail Add-in also to do what you want http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "John M" wrote in message ... I e-mail a spreadsheet to obtain a wide range of user information. The file has many graphic objects, controls and macros controlling user action and responding. Following the user's response I have the data e-mailed back by macro, but do not need the macro's or any user interface anymore. The file is 660KB in size (with the macros). After deleting all graphic objects, text and formats, the file that gets e-mailed is still 490KB in size. There are ± 700 event handlers in the macros. These can all be deleted before e-mailing. Is there a way to address macro modules from another macro, specifically to delete them? |
Delete macros in another macro
Thanks. These links solve my problem. It has been most helpfu
Regards |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com