Hello, all. I'm going round and round with this one.
I have a number of scripts which gather data, open Excel files the user chooses, write date, set formatting, save the worksheet and close it.
This only works if the workbook is closed. I understand this is a known issue. I test for the worksheet being open by seeing if I can open the file for writing, then warn the user.
I would like to take the scripts up a notch, and let the user choose from worksheets which are already open. I unde