vijayabhaskarr

 Profile Answers by vijayabhaskarr 

• Mar 1st, 2007

 

1) First you create Excel Object with the below statement.
 Set objExcel = CreateObject("Excel.Application")
2) Open the work book
objWorkBook = objExcel.Workbooks.Open(FileName:=sFileName)
3) Open the sheet where you want to enter the information
Set objWorkSheet = objWorkBook.WorkSheets(vSheet)
4) Enter the value in cell where you want.
objRange.Rows(i).Columns(m).Value= "TestData"

mndhinesh

 Profile Answers by mndhinesh 

• Aug 6th, 2009

 

    Dim FilePath
    Dim FileNumber
    FileNumber = FreeFile
    FilePath = "E:abc.xls"

   Open FilePath For Output As FileNumber

  Write #FileNumber ,"data1,data2,data3"