Excel vbscript


#1

Hi please can any one tell from below excel screen sheet

From column 1-oct-17 when it reaches jth row than i needs to start from (C2) column three 2-oct-17

How to do this in vbscript


#2

Dim xlApp
Dim xlBook
Dim xlSheet
Set xlApp = CreateObject(“Excel.Application”)
xlApp.visible = true
Set xlBook = xlApp.Workbooks.open(“D:\Macro\BirthDay.xls”)
Set xlSheet = xlBook.Worksheets(“Sheet1”)
MsgBox xlSheet.Cells(1, A1).Value

Please refer this link: https://stackoverflow.com/questions/29540118/reading-all-rows-of-a-specific-column-in-excel-with-vb-script

if you iterate and do increment and change column and row values then you can achieve your desired cell values.