View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mdup mdup is offline
external usenet poster
 
Posts: 7
Default Creating Excel Sheet using VB 2005



"mdup" wrote:

I am trying to connect to servers and import data and attributes from the
servers into excel. What is the best way to do this? I have to connection
part of the code wriitten and can connect to any server I choose. I am now
working on creating the excel spreadsheet with the data.

I have Imported the Microsoft.Office.Interop.Excel package into my program.
Should I be using the ListColumns.Add and the ListRows.Add functions to
populate the spreadsheet from the data imported by the server?

Thanks in advance.