Copying and Pasting Channels

[aGrimm]

When copying and pasting channels is there a way to leave out the name of the channel?  Whenever I copy and paste a channel into excel the name of the channel is always pasted with the data in the channel.

I just want to copy the data of the channel and leave out the name.

[James_D]

Hmm. can you specify what you're doing exactly that's leading to that? It's not a problem I'm encountering.

[Twigeater · Accepted solution]

Hello!

This code does the job:

Option Explicit

Dim s

Call ChnClpCopy("1-4")

s = TextFromClipBoard()
s = Mid(s, InStr(s, vbCRLF)+2)
TextToClipboard( s )

You might add some code to make it bullet proof 😉

Matthias

[aGrimm]

Works like a charm.

Thanks again Matthias.