Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Write Heading in excel
#19
Solved: 11 Years, 3 Months, 2 Weeks ago
i did not understand but i am pasting the code which i am using :
CODE:---------------------------------------
Code:
SystemUtil.Run "F:\Program Files\Internet Explorer\iexplore.exe","","F:\Documents and Settings\Anu","open"
Browser("Browser").Page("Page").Sync
Browser("Browser").Navigate "http://google.com/"
Browser("Browser").Page("Google").WebEdit("q").Set "header"
Browser("Browser").Page("Google").WebEdit("q").Submit
'For Wirting in Excel Sheet’
Dim xlApp, xlBook, xlSheet ,sHeaderArray()
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.WorkBooks.Open("F:\Test.xls")
Set xlSheet = xlBook.WorkSheets("Sheet1")
'*** Writing Header***'
      i = 0
    For Each sHeader in sHeaderArray
        i = i + 1
        ExcelSheet.ActiveSheet.Cells(1, i).Value = sHeader
    Next
' Save the sheet.
xlBook.Save
' Close Excel with the Quit method on the Application object.
xlApp.DisplayAlerts = False
xlApp.Quit
' Release the object variable.
Set ExcelSheet = Nothing
Set objExcel = Nothing
Reply


Messages In This Thread
Write Heading in excel - by Anu - 07-01-2010, 06:13 PM
RE: Write Heading in excel - by sreekanth chilam - 07-01-2010, 11:10 PM
RE: Write Heading in excel - by Anu - 07-12-2010, 01:37 PM
RE: Write Heading in excel - by basanth27 - 07-13-2010, 09:56 AM
RE: Write Heading in excel - by Anu - 07-13-2010, 02:34 PM
RE: Write Heading in excel - by sasmitakumari - 07-13-2010, 02:58 PM
RE: Write Heading in excel - by Anu - 07-26-2010, 11:40 AM
RE: Write Heading in excel - by sasmitakumari - 07-26-2010, 05:24 PM
RE: Write Heading in excel - by Anu - 07-26-2010, 05:35 PM
RE: Write Heading in excel - by sasmitakumari - 07-26-2010, 07:14 PM
RE: Write Heading in excel - by Anu - 07-27-2010, 11:13 AM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 11:27 AM
RE: Write Heading in excel - by Anu - 07-27-2010, 12:02 PM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 12:15 PM
RE: Write Heading in excel - by Anu - 07-27-2010, 12:27 PM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 01:01 PM
RE: Write Heading in excel - by Anu - 07-27-2010, 01:55 PM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 02:20 PM
RE: Write Heading in excel - by Anu - 07-27-2010, 02:23 PM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 02:55 PM
RE: Write Heading in excel - by Anu - 07-27-2010, 05:55 PM
RE: Write Heading in excel - by sasmitakumari - 07-27-2010, 08:21 PM
RE: Write Heading in excel - by Anu - 07-28-2010, 10:34 AM
RE: Write Heading in excel - by Anu - 07-30-2010, 11:46 AM
RE: Write Heading in excel - by sreekanth chilam - 07-30-2010, 03:33 PM
RE: Write Heading in excel - by MVChowdary - 07-30-2010, 07:23 PM
RE: Write Heading in excel - by Anu - 08-03-2010, 10:37 AM
RE: Write Heading in excel - by Anu - 08-05-2010, 03:02 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Write in Excel Continued Anu 3 3,303 08-27-2010, 08:53 AM
Last Post: basanth27
  Write in Excel Anu 48 31,378 08-25-2010, 06:08 PM
Last Post: Saket

Forum Jump:


Users browsing this thread: 4 Guest(s)