When I leave the file name:=name.xlsx it saves the file to 'my documents'. The template file is opened from a folder on the shared drive and I just want to saveas and rename the file base on a cell.
I've thought about using URL location to map it to S:/operations/scheduling/daily schedules/ but can't figure it out.
Thanks for all the help! Y'all are amazing!
Bookmarks