What you can do is, instead of having to export as excel file, export as xml file and then you can open it in excel. I also know there is a way to export as excel, but need never done that. I hope this will help. Below is the code I used (three lines).
SqlDataAdapter1.Fill(DataSet1)
Dim...