Why does my VBA macro end after opening file?

I actually used NotePad as an intermediate. Bloats shouldn't have copied through there, right?

I assumed you were copying from a module and pasting into a new module in a new workbook.

MSC = MS Clipboard
I am not an expert on the finer points of MSC.
In your case when copying from module to MSC, the previous item is cleared and stores the new item (module), maybe including stuff we dont know about. Considering MSC also copies formatting of Word data (incl formatting) -- text, images, files etc.
But when you copied to Notepad (which results in text only) and recopied Notepad to MSC -- MSC would again clear the old item to hold the new "pure text"

If you want to play with MSC and see just what it holds, create a shortcut to

Code:

C:\WINDOWS\system32\clipbrd.exe

... ie, clipbrd.exe not clipboard.exe
A window that shows the current clip, and you can clear MSC from the same window.
(Almost as exciting as watching paint dry )

I love VBA probably because I have used it since WordBasic days. But I do acknowledge it is prone to instability. VBA has always satisfied all my needs

Regards,
Russell