How do I extract excel filename from a user-selected file?
Folks, I can't seem to figure out how to extract the original file name of an Excel workbook that a user selects. After selecting the appropriate file as shown below, the actual file name I get is the worksheet name (sheet 1), not the original file name (test_data.xls). I'm ultimately trying to rename the originally selected excel file and need the file name, not the opened worksheet name, to a...
sibylle_herzer
Steven_Moore
sophiaw
saitcopuroglu