vba to send data to excel from single clipboard

[reteptnarg]

Aloha , I have written an autohotkey script to parse and rearrange a complex pipe delimited text file . I currently have it working by sending F5 and pasting the R1C1 cell location and then pasting the data etc but it's slow and screen 'flashy'.
I'd like to call a macro to have it quietly paste the clipboard but I need some help figuring out how to split off the R1C1 info ( which I can have be the first characters in the clipboard string
and followed by any delimiter ... the rest of the data on the clipboard will be the 'down the column' `r`n cells I am trying to paste.

all I've got so far is the simple ( I know no vba ) macro for R1C1 = r30c4

Please Login or Register  to view this content.

I removed the worksheet reference above since i just want the activesheet .

and once i figured out how to find FM20.dll and create a userform to activate it, I can get the snippet from mikerickson at http://www.mrexcel.com/forum/showthread.php?t=321833 to work :

Please Login or Register  to view this content.

Anybody kind enough to help me with a robust vba macro that will split the clipboard and grab the first part of the string on the clipboard enclosed in parenthesis (%row%,%column%) and assign it to a var1, and remove that data, so I can have the macro then paste the remainder of the clipboard ?
ActiveSheet.Paste Destination:=Cells(var1)

[reteptnarg]

I didn't get any responses but did manage to get some help at http://www.experts-exchange.com/Soft...html#a36250099

I'm posting here in case anybody else is stumped like I was ... it's handy to be able to send the cell address and contents in a single clipboard to excel

Please Login or Register  to view this content.