I have written some scripts to assist staff with an import/export to file match Excel data for another system. The scripting in FMP works great for this, however, one of the Excel files comes to us password-protected.
I don't want staff to have to monkey around with the password issue pre-import but would rather like to include scripting language which would detect that in the file, then allow whomever is running the process to be able to enter the password (which changes from file to file) then have the script continue from there.
Is this even possible? Would Set Error Capture catch that? I could not find an error code for this; could I make my own custom error code?
Thank you for any/all help and advice.