Hi there! I am hoping someone can help me with this one. Everyday I open one spreadsheet and immediately open another from a coworker to import their data into my open spreadsheet. Is there a way when opening my spreadsheet to immediately be prompted to open my coworker's spreadsheet (the name changes daily) and then save it with a given name? I found a sample code to open a file (I'll paste it below) but it closes the file right after opening and I'd like to save the file and keep it open. It is worth noting this will be on a Mac running Excel 2011.

Thank you!!!

Here the found code:

Please Login or Register  to view this content.