InfoPath om MOSS 2007 Current User Profile

Here is a blog to get the current user information without having to write a code and it works like a charm. Keeping a link here to for reference:

InfoPath - blog from Itay Shakury

InfoPath - Get user information without writing code (extended) - Clayton Cobb

Excel Tip – Show Hyperlinks

How to extract Hyperlinks in EXCEL. Create a module (User-Defined function) as described below. Save and use it as you would like a formula.

 

Function GetURL(rng As Range) As String

On Error Resume Next

GetURL = rng.Hyperlinks(1).Address

End Function