VBA question
Apr. 4th, 2007 03:30 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
selenayThis may be a long-shot, but...
Does anyone know how to use VBA to send an email with an embedded Excel chart? I've been wracking my brains, Googling obsessively and glaring at code, but to no avail. Recording the action as a Macro in Excel isn't helping because it doesn't show me doing the bit where I use File/Send To and definitely won't see anything I do in Outlook.
*sigh*
Got such a headache.
The good news is that the boss approved the VBA books I found so I'll be ordering them tonight and putting in an expenses claim. Woo!
Hopefully I'll at least find a hint about it in one of them. I feel rather less like Queen of Code than I usually do right now.
Guess I really need that pub trip with The Girls tonight.
Does anyone know how to use VBA to send an email with an embedded Excel chart? I've been wracking my brains, Googling obsessively and glaring at code, but to no avail. Recording the action as a Macro in Excel isn't helping because it doesn't show me doing the bit where I use File/Send To and definitely won't see anything I do in Outlook.
*sigh*
Got such a headache.
The good news is that the boss approved the VBA books I found so I'll be ordering them tonight and putting in an expenses claim. Woo!
Hopefully I'll at least find a hint about it in one of them. I feel rather less like Queen of Code than I usually do right now.
Guess I really need that pub trip with The Girls tonight.
