Hello all,

I'm using Excel 2010 to pull data from multiple pages of a website. I have successfully imported the data using the code from this thread: http://www.excelforum.com/excel-prog...ites-loop.html

My issue is that I cannot keep the data in HTML format (I need to preserve the links, not just provide the text name of the links). I thought it was as easy as changing ".WebFormatting = xlWebFormattingNone" to ".WebFormatting = xlWebFormattingFull" but it appears I'm wrong. Can anyone educate me on how to resolve this.

I greatly appreciate any help.

Jason