I have a folder with several hundred documents. I also have an Excel file, where column A contains file names of these documents and column B containse some description for each of these documents. Is it possible to have a custom column in Directory Opus, which would look for a file name in Excel file and show the corresponding description.
Excel has an automation interface so that should be possible.
That said, Excel is not always great at running in the background, nor at having the same sheet open in multiple instances. Converting the sheet into something that the script code could parse directly, without Excel being involved, would probably give you a more robust method. But that trade-off may or may not make sense depending on how you need to use the column and edit the Excel data.
OK thanks, will try that.