Hi 623bookends,

Welcome to the forum.

By saying "automate the entry of the spreadsheet file name into a cell", do you mean to extract the file name of current file which you have opened on your system... ?
i.e., if I open a workbook "sales.xls" and I want the name "sales" to be automatically extracted in a cell ?
thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>