Result.xlsm is the Master workbook where the macro code is seated. The Prnjobs.vbs script provides a print job monitoring utility that allows you to pause, resume, cancel, and list print jobs. You just tell the code to perform one action if a condition is true (in this case If i10). Set objExcel = CreateObject("Excel.Application")Īnd finally the bat file i intend to run the vbs with: cscript script.vbs "C:\Users\G852589\cnq transfer\Result.xlsm" Sheets("Sheet1").Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Set wkbSource = Workbooks.Open(strPath
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |