I have employed the SubWorkbook_BeforePrint VBA to get all new files to print the path name in the excel spreadsheet footer. Works great!
But, this doesn't work for existing files - even if I save them with a new name. Does anyone have a way to get the filename and path to print in an previously existing excel document?
But, this doesn't work for existing files - even if I save them with a new name. Does anyone have a way to get the filename and path to print in an previously existing excel document?