How can I Write data into External Excelsheet using RR.

Showing Answers 1 - 6 of 6 Answers

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"

  Was this answer useful?  Yes

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"


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions