Bulk Copy Paste in MS Excel w VBA

[Jeroen Eynikel]

Hi,

there used to be VBA code 'out there' by Ben Hill I think that allowed bulk copy/paste to work on a TM1 Excel sheet while keeping the DBRW's intact.

Does anyone still have this lying around? And If so would you be kind enough to post it?

Thanks,

Jeroen

[Wim Gielis]

Hello Jeroen

I don't know about that code, perhaps someone else does, but how about writing it again as a piece of generic code?

Greetz,

Wim

[Alan Kirk]

Hello Jeroen

I don't know about that code, perhaps someone else does, but how about writing it again as a piece of generic code?

I've heard of it, but don't have a copy either. However the functionality will be in the next release of the TM1 Tools add-in that Martin, Steve and I have written. I'm about half way through it but it needs some speed tweaks as well as some extra flexibility. Don't particularly want to commit to a timeframe but it'll probably be in the next couple of weeks.

[Kyro]

I would put it up again but I think a friend of mine has a better version - Michael Mackie - I'll redirect him here.

Kind Regards,
Ben Hill

[Jeroen Eynikel]

I would put it up again but I think a friend of mine has a better version - Michael Mackie - I'll redirect him here.

Kind Regards,
Ben Hill

That would be much appreciated.

Jeroen

[Alan Kirk]

the functionality will be in the next release of the TM1 Tools add-in that Martin, Steve and I have written.

This has now been posted in the Useful Code forum.

http://forums.olapforums.com/viewtopic. ... 289#p11289