vbscript - Copy and modify values in Excel -

vbscript - Copy and modify values in Excel -

i doing job in regular basis. want automate job using vbscript.

query

i wanted re-create 1 excel file folder folder b has been created today , want alter value.

condition

i don't want same file re-create twice.

and want alter values in column h 1 instead of 0.

hope clear.

could please help me on this?

regards,

nanthini

i hope below link woould help you. , if doesnot please eloberate question.

http://easyprograming.com/vb-script-articles/17-moving-and-renaming-files-in-vb-script/

and alter values of columns can utilize below code:

excelpath = "<<path>>" 'excel path set objexcel = createobject("excel.application") 'excel object set currentworksheet = objexcel.activeworkbook.worksheets("<<sheet name>>") left = currentworksheet.usedrange.column set cells = currentworksheet.cells 'loop iterate through th columns row = 0 (usedrowscount-1) cells(row,8).value = "1" next

excel vbscript