You can use Open URL to the directory path.
you can make a script
Go to layout and specify the layout you like
save records to excel from from the records item
usually, when it opens the dialog to save to excel, it will ask you if you want to open the file after saving, just check that box.
I hope it works