Hello I am trying to export a datagrid to an excel file using VB.NET. I can do it in ASP.net like this: Dim oDS As DataSet = reports.GetDataset(StoredProcedure, oparams) Dim DG As New DataGrid DG.DataSource = oDS DG.DataBind() Dim stringWrite As New System.IO.StringWriter Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite) DG.RenderControl(htmlWrite) reports.WriteFile(stringWrite.ToString, FileName) (where reports contains all my functions) but this method doesnt work in VB.NET as these two lines cannot be used in VB.NET: Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite) DG.RenderControl(htmlWrite) Does any one know of an alternative cos I'm stuck! Thanx Bex

Ok.. worked it out... did not realise I could reference the system.web namespace in a vb.net app... I can use the code listed above! duh!