defined names

[ehsas]

How can i copy the defined names from one workbook and paste the same into another workbook.Regards

 

[Andrew Poulsom]

The workbook into which you want to copy the names msut be open. Is it?

 

[ehsas]

yes it open.Tell me does it need to be as c:book2.xls or it just need to be open.
I have tried both by still.Regards

 

[Andrew Poulsom]

If it's open and it's named Book2.xls then:

NewBook = "Book2.xls"

 

[ehsas]

I tried with simple defined names it working but when I am trying with workbook having following defined names it giving error messeges.

=OFFSET(carsold.xlw!xvalues,2,0)
=9.99999999999999E+307
=OFFSET(carsold.xlw!xvalues,3,0)
=OFFSET(carsold.xlw!xvalues,1,0)
=OFFSET(sheet1!$C$6,0,COUNTA(bignum,sheet1!$6:$6)-13,1,13)

regards,

 

[Andrew Poulsom]

Well you can't have everything!

For items 1, 3 and 4 I think carsold.xlw needs to be open.

I'll have a think about the other two.

 

[ehsas]

let me tell you that for test purpose i have made similar defined names in book1 and run your macro it is working.but when trying from carsold workbook it is not working.What can be the problem.Regards,

 

[Andrew Poulsom]

Either:

1. Copy the code to the carsold workbook and run it from there, or
2. To run it from the original workbook change

For Each nm In ThisWorkbook.Names

to

For Each nm In ActiveWorkbook.Names

 

[ehsas]

I tried but still not working.Regards,

 

[ehsas]

could any help as i mentioned in above post i am not able to run the macro.Regards.

 

[NateO]

Seems Nate does not use Option Explicit.

Yeah, bunk variable! ****, I do use it sometimes, but not in this case... It would still work if the end-user isn't using strict variables...

I went back and fixed the code. Sorry 'bout the goof!