how to embed macro into new/create spreadsheet from outside of EXCEL?

[Stuart Slom]

I'm want to create a workbook that contains an auto open macro that I
can then email to a business user. However, this must be done outside
of Excel. In other words, I want to create a Workbook generated from
outside of Excel like a downloaded .CSV file that has an Autpen macro
already built into it so I don't have to open the workbook just to build
the macro into it. Any help much appreciated. Thank you, Stuart

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Dave Peterson]

The .csv files are plain text. Open one up in Notepad and you'll see that it's
just typing.

These .csv files don't contain formatting or macros.

Depending on what you're doing, maybe you can use another workbook that contains
the macro that sends the file.

If you think you want something like that, you can steal lots of email code from
Ron de Bruin:
http://www.rondebruin.nl/

or from Dick Kusleika:
http://dicks-clicks.com/excel/olAutomating.htm
(especially useful if you're using Outlook as your email client)