Text Functions on Cell Formula

[Alkemist]

Hia...

Quick question...I have some cells that contain links to other workbooks.

I'd like to extract some information about the link, ie, use mid, left, right, len etc...

I know how to use this with cells that contain text, is there a way to use them with cells that contain formula's?

Cheers...A

 

[reneuend]

strFormula = ActiveCell.Formula

This will extract the formula of a cell to a string. Then you can parse it from there. Does that help?

 

[Alkemist]

Thanks mate and sorry for the delay in picking this up!

That would give me a work around which I suspect is the way I'll need to go.

I was wondering if there were any functions within XL that could do this without having to go to VB.

Cheers..A

 

[reneuend]

Sorry for the misunderstanding. I'm afraid I don't know the answer to that as I spend most of the time in VBA. You'll probably want to repost your message with the XL caveat.

Best Wishes,
reneuend