T
transferxxx
Does anybody has a macro which would add the file name of my active
workbook to all sheet name of the workbook
eg if file name is file.xls & sheetA & sheetB & sheetC
macro will rename sheets as foll:
sheetA - file (without extension ".xls")
sheetB - file
sheetC - file
thxs
workbook to all sheet name of the workbook
eg if file name is file.xls & sheetA & sheetB & sheetC
macro will rename sheets as foll:
sheetA - file (without extension ".xls")
sheetB - file
sheetC - file
thxs