View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Explanation needed for CopyAllModules code

Chip is a belt and suspenders type person.

He wants to make sure that there is no file with that name. In my tests, it
didn't matter. The existing file was overwritten.

And if you step through your code against a test workbook, you can open that
code.txt file. You can see it contains the code of each of your modules.

Just like if you rightclicked on the module and hit "export file".

davidm wrote:

Thanks, Dave for being so obliging. I am still not a bit confused.
Regarding the first *KILL*, my query is: why kill the filename (or have
it overwritten) and yet in the next move export same? May be I am not
fully appreciating what the "code txt.file" is. Further light, Dave.

--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=386689


--

Dave Peterson