Copy and Paste a range of cells into DBRW

[Rashed]

Hi guys....not sure if this has already been posted before. Is there any way to copy and paste a range of cells into a DBRW range of cells? Thanks in advance.

[John Hobson]

You need to write a little bit of VBA code that

* captures the copy value
* loops through the target range
* retrieves the element co-ordinates on a cell by cell basis using the parameters of the DBRW formula
* does a DBS of the copy value using those co-ordinates
* replaces the DBRW formula
* moves to the next cell

It's fairly trivial. ISTR that something has been posted here before that did this.

Edit - perhaps less trivial range to range than cell to range but still quite doable

[paulsimon]

Rashed

You can write your own as John suggested. Cubewise do a tool that will do this. The Beachware tool did it a long time ago, but I am not sure if it is still around. Applix bought Beachware a long time ago so I am not sure why this feature never made it in to the product.

Other alternatives are to use the Cube Viewer, TM1 Web or the In-Spreadsheet Browser, neither of which use DBRW. However, the ISB is being dropped after version 9.4.

Regards

Paul

[Alan Kirk]

Hi guys....not sure if this has already been posted before. Is there any way to copy and paste a range of cells into a DBRW range of cells? Thanks in advance.

As per John's comment, VBA will do it for you. It's also part of one of the packages put out by SPF (http://www.spfplus.com/), which may be worth looking at if you have the need.

[Rashed]

Thanks Guys...this forum is awsome!!!!

[Alan Kirk]

You can write your own as John suggested. Cubewise do a tool that will do this. The Beachware tool did it a long time ago, but I am not sure if it is still around. Applix bought Beachware a long time ago

I wouldn't say that in front of Johann Potgieter if I were you... not unless you're wearing gridiron padding.

Beachware is what became SPF.

[John Hobson]

Yes if memory serves me well didn't someone buy the name but forgot to buy the product or something or was it the other way round.

It's a long time ago but there was a funny story there somewhere...

SPF was/is quite a neat tool. (Neat at that UI level that Applix never ever managed to get right or copy properly.)

[Steve Rowe]

You can also consider using DBS(W) for sending the data in. SInce the source is ordinary excel you can copy and paste to your hearts content then.
Cheers,