I've tried unsuccessfully to modify the simple script below to open a specific worksheet when it opens a workbook.
Set xl = CreateObject("Excel.application")
xl.Application.Visible = True
What is the correct syntax to cause it to open say sheet 'SomeSheetName' in each of the two workbooks (the sheets each have different sheetnames in the various workbooks I'll be opening).
Ideally, I'll want to modify this script so that it first sets several, say five, pathnames, then calls the script as a sub to iteratively open each one.