Excel stops responding after attaching worksheet to email

Excel stops responding after attaching worksheet to email

Post by c2pz » Thu, 09 Oct 2008 23:46:07


When I select send to as attachment and send a worksheet Excel stops
responding and I have to terminate it in task manager. When I check my
outlook sent items the email was sent and the attachment is there. I have
Excell 2003 SP3. This used to be sporatic and is getting more common.
 
 
 

1. How can you attach an e-mail into an excel worksheet?

2. Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet

I am writing a VB DLL / xla that needs to be able to programmatically attach
a JET database to a worksheet, and then re-open it later on. This needs to
happen without user intervention. So far I have considered the following:

1) Using the Insert Object approach to store the database in an OLE
object...BUT:
(a) How do you do it programmatically?
(b) It seems to be application specific, so would only work if the user
had Access.
Is there a generic object packager that I have missed, and that can be
called through VB code, and that is guaranteed to be on all machines?

2) Reading the JET database into a byte array, converting to a string, and
saving in the workbook...
The read and convert seemed to work OK but all attempts to save to a
workbook failed, even if I just try to save the first 100 characters. I
guess that the string contains *** characters that excel won't allow to be
saved to a cell? Is there anwhere else I can save it in a workbook?

A related question is whether it is possible to re-open the JET database
without first saving to a file i.e. open it in-memory only. I know this
isn't an Excel question but someone might know the answer.

Thanks in advance,

Ant Waters

3. WMP 9 Stops Responding and Causes Windows XP to Stop Responding Also

4. Outlook 2003 attach File Browse Window Stops Responding

5. Outlook stops responding when trying to attach a document

6. IE6 stops responding when not attached to home wireless network!

7. file menu open of a worksheet makes XL2000 stop responding.

8. Sending an EMAIL plus attached Excel file using Excel VBA

9. excel won't automatically open attached email excel files?

10. outlook express 6 not responding after receiving email with attach

11. OE "freezes/not responding" due to large attached file in Outbox e-mail

12. Is there a way to directly attach emails or email attach to access

13. Attach audio clip to an Excel worksheet?

14. How do I attach an Excel worksheet to a thread without including personal information