I need to capture the document Name/worksheet name into a cell - "Not" a file Path or a file name. The specific Excel spread sheet or sheets name.
E.G. - Excell spreadsheet name = Sample 123
Sample 123 - needs to automatically be captured in Column 1 Row 2
Note: Due to business rules the spreadsheet name cannot captured in headers and footers.
Is anyone able to give sound advice on this problem?