Search results

I am using the following code to populate excel cells on a worksheet: Private Sub CreateCheckList_Click() Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook = objXLApp.Workbooks.Open("C:\JOB_CHECKLIST.xltm")...

How would you use the code above to populate fields across multiple worksheets?