function writefail(r)
oSheet.cells(r,5).value="INVALID as P"
End function
Dim oExcel, oWB, oSheet, getVal
Set oExcel=CreateObject("Excel.Application")
Set oWB=oExcel.Workbooks.Open("C:\Users\sunshine\Desktop\Macro\Data.xlsx")
Set oSheet=oWB.WorkSheets("Sheet1")
oExcel.Visible=TRUE
for r =2 to 14
status=oSheet.cells(r,4).value
if status="P" then oSheet.cells(r,5).value="INVALID as P"
'if status="P" then writefail(r)
do
'if status="P" then _
'writefail(r)
'exit do
'if status="P" then _
'oSheet.cells(r,5).value="INVALID as P" exit do
'loop while false
if status="P" then exit do
if status<>"P" then _
oSheet.cells(r,6).value="V1"
oSheet.cells(r,7).value="V2"
'oSheet.cells(r,5).value="VALID"
exit do
'loop while false
loop while r<6
Next
oWB.save
set oExcel=nothing
oSheet.cells(r,5).value="INVALID as P"
End function
Dim oExcel, oWB, oSheet, getVal
Set oExcel=CreateObject("Excel.Application")
Set oWB=oExcel.Workbooks.Open("C:\Users\sunshine\Desktop\Macro\Data.xlsx")
Set oSheet=oWB.WorkSheets("Sheet1")
oExcel.Visible=TRUE
for r =2 to 14
status=oSheet.cells(r,4).value
if status="P" then oSheet.cells(r,5).value="INVALID as P"
'if status="P" then writefail(r)
do
'if status="P" then _
'writefail(r)
'exit do
'if status="P" then _
'oSheet.cells(r,5).value="INVALID as P" exit do
'loop while false
if status="P" then exit do
if status<>"P" then _
oSheet.cells(r,6).value="V1"
oSheet.cells(r,7).value="V2"
'oSheet.cells(r,5).value="VALID"
exit do
'loop while false
loop while r<6
Next
oWB.save
set oExcel=nothing
No comments:
Post a Comment