AddFromString Code -> Excel crashes ... Why ?

MichDenis

Guest

Posts: n/a

15th Jan 2007

Hello,

If someone knows why we cannot use this line of code in a loop
without a crash of Excel ?

'-----------------------
With ThisWorkbook.VBProject.VBComponents(Worksheets(MyVar).CodeName).CodeModule
.AddFromString Code
End With
'-----------------------

Thanks in advance for your collaboration and your time.

Salutations.

« Copy / Paste between workbooks into a specific worksheet query?! | data ranges »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
this code crashes excel. How come?	=?Utf-8?B?Tm9sYXVnaG10cg==?=	Microsoft Excel Programming	3	13th Sep 2007 05:22 PM
VBA code ok in Excel 2003, but crashes Excel 2002 & 2000	=?Utf-8?B?dG9tZ3JlZW4xMDAw?=	Microsoft Excel Programming	5	6th Jul 2007 07:46 AM
VBA code crashes Excel 97 - Help please!	GB	Microsoft Excel Programming	4	14th Apr 2007 07:15 AM
Code that Crashes Excel without fail - Excel 97 SR2 WinNT	Matt Jensen	Microsoft Excel Programming	14	10th Jan 2005 03:08 PM
InsertLines and AddFromString crash excel	Chip R.	Microsoft Excel Programming	1	13th Aug 2004 03:28 PM