when assigning WorkbookReporter.ConnectTo(), it will attach to any worksheet.
if you try to run WorkbookReporter.Start() subsequently, a runtime error will occur if the sheet connected to does not contain specificly named ranges and shapes.
it would be great if Start() or Initialize() could do the following
me.pSheet is null => create a new sheet with pretty report formatting and the required shapes and ranges
me.pSheet does not contain each of the required named ranges or shapes => create these entities, or describe to the user why it can't continue, and how to fix it.
when assigning
WorkbookReporter.ConnectTo(), it will attach to any worksheet.if you try to run
WorkbookReporter.Start()subsequently, a runtime error will occur if the sheet connected to does not contain specificly named ranges and shapes.it would be great if
Start()orInitialize()could do the followingme.pSheetis null => create a new sheet with pretty report formatting and the required shapes and rangesme.pSheetdoes not contain each of the required named ranges or shapes => create these entities, or describe to the user why it can't continue, and how to fix it.