dim xls_sheet,xls_app set xls_app=createobject("Excel.Application") Set xlwb = xls_app.Workbooks.Open(jcdest & "jc_template1.xls") set xls_sheet = xlwb.sheets("Sheet1") xls_sheet.ActiveSheet.cells(r,3)= val xls_sheet.ActiveSheet.cells(r,2)= trim(fn) xls_sheet.ActiveSheet.cells(r,1)= trim(ln)
|VB Script: compare csv files based on a key column and report third file with differences values||17||35|
|Modification on userform and column K||47||38|
|Running Access application from Task Scheduler||6||34|
|change the windows script file to BAT||10||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!