How to Delete ALL Defined Names in a WorkBook Dynamically created from a Single Sheet

[e4excel]

How to Delete ALL Defined Names in a WorkBook Dynamically created from a Single Sheet?

I am creating some Files or WorkBooks Dynamically everything is fine however the purpose of creating this is to just have the Data BacK up with only Values and Formatting and No Formulas...

But after checking the New WorKBook it has all the Defined Names from the Parent MasterSheet..

IS is t possible to delete ALL the Defines Names when it is being created ?

While GOOGLING on this issue I found some code which I tried in vain..
http://www.ozgrid.com/forum/showthre...t=20268&page=1

Richie's Code

Sub RemoveNames()
Dim nm As Name
Dim NewWkBkName As String ' My New Line
NewWkBkName = Sheets("PassBook").Range("U5").Value ' My New Line

For Each nm In NewWkBkName.Names 'ThisWorkbook.Names
nm.Delete
Next nm
End Sub

Just to explain where Im going wrong Im enclosing it in Quotes..please excuse..!

I am unable to attach a WorkBook as the file contains all confidential information so please pardon me for the same.

Warm Regards
e4excel

[e4excel]

The problem is I cannot use

ThisWOrkBook as it deletes the Names from the Parent Workbook as we still are in it

So is there a way of doing it from the Parent WorkBook without deleting the Names in it..

[mikerickson]

Try

Please Login or Register  to view this content.

[e4excel]

Thanks Mike it worked well..

I had also got it working but I was adding the code in the loop unnecessarily using the concept of Active WorkBook but this was irrespective of that..

I knew what I wanted but dint know the Syntax as I am not well-versed with VBA..

Warm Regards
e4excel