Hi

I'm currently pulling data from SQL Server and storing it to a recordset. One of the fields is called 'URL' and contains a URL which I'd like to use to create another field into a hyperlink but then I don't want 'URL' added to the worksheet as a separate column.

So basically I'm asking how I could manually cycle through a recordset and choose what and how fields are added to the worksheet?

Cheers
Tommy