How to paste multiple values into DBRA

[pmakulski]

I'm trying to add a passel of Names to a dimension. I have already added the elements by pasting them into the dimension editor.
I'd paste the names into the Attribute editor, but the order in the attribute editor is different and I can't see any way to sort what shows up in this editor.

So, I got the brilliant idea of using Excel.
I have a three column spreadsheet like this:
A: Item B: DBRA("Server:Item", $A1, "LongName") C: The long name

If I just use excel to copy and paste C1 to B1, it works (it puts the value into the TM1 Attribute in the database)
But if I copy C1:C100 and paste it to C1 the DBRA formulas in B1:B100 disappear and are replaced with the pasted values (the values don't make it to the database)
(I tried paste, paste as values, I tried pasting from Notepad, nothing works)

I tried writing a macro. I recorded a macro of me doing it once. The macro created uses hard references: e.g. Range("B1").Select
When I try and generalize the references, it doesn't work. It replaces the DBRA formula with the value (even though when I recorded it it worked perfectly.

I'm going to do one hundred copy and pastes by hand, because I'm in a hurry.
But if anybody can tell me how to paste multiple values into multible DBRA's, I'd appreciate it for next time.

9.5.2 Excel 2003

[lotsaram]

Downlad the TM1 tools add-in!

[pmakulski]

Cool.

I found a link to it http://www.tm1forum.com/viewtopic.php?f=21&t=2515.
Is there a better place to find it?

Thanks