A SheetName Marker is used in a Source Workbook to change the name of a worksheet in your Generated Workbook at runtime.
Never give a SheetName Marker the same name as an existing Sheet! This will crash Excel.
- All SheetName Markers begin with a $$
- SheetName Markers retreive their names from Variables that have been added with the AddVariable method
$$NewSheet1Name refers to the NewSheet1Name variable that you have added with the AddVariable method
Example
myXLS_obj.AddVariable "NewSheet1Name", "10 Items" ' Replace the $$NewSheet1Name with 10 Items
Source Workbook
Change the Sheet Name to $$NewSheet1Name
Generated Workbook
