Excel Crashes when adding code to workbook via VBA

Hi Everyone,

I thought I had this fixed late yesterday, But the same problem happened again this morning. This all generated from this post
http://www.excelforum.com/excel-prog...ml#post2073179

The code below resides in my personal.XLS Module. When I step through the code everything works till it reaches the point in red then I get the pop up that says excel needs to close and asks to send or not to send.

I noticed that if I choose recover my work and restart excel and I look at the code in THISWORKBOOK of the recovered workbook that the code I wanted placed there is there.

Can anyone explain why this is happening? I have the macro's security set to low and a check mark in the trust access to vb projects.

Any Idea's how to fix this?

Thank You again for your contiued support!!!
Mike

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Cross posted to get a wider range of help
http://www.mrexcel.com/forum/showthr...90#post1900890

Hello realniceguy5000,

This macro is a little longer, but safer to use.

Please Login or Register  to view this content.

Hello Mike,

I have put the corrections in blue. The only optional argument is the boolean variable Overwrite. Set this to true if you want to overwrite the file's previously saved contents.

The macro knows where the file is because it appears in your code. The full file path appears in your macro OpenALL(). The full path is given as "C:\Documents and Settings\MAlston\Desktop\Count Sheets\mycode.txt"

Please Login or Register  to view this content.

I have the macro's security set to low ...

RNG, that is an invitation to an ocean of heartbreak.