Hi, I have an excel spreadsheet with an OLE object showing another excel spreadsheet.
I would like for the user to be able to select a unique identifier (product code) and have the OLE object update to the file that matches that product code (e.g. drop down select code "SG05", OLE object changes to the document titles SG05 in the same directory.
I tried doing this manually and although double clicking opened the document for SG05, the OLE object still displayed the original file I created the OLE object with.
Any thoughts on how to do this please?
Cheers.
I would like for the user to be able to select a unique identifier (product code) and have the OLE object update to the file that matches that product code (e.g. drop down select code "SG05", OLE object changes to the document titles SG05 in the same directory.
I tried doing this manually and although double clicking opened the document for SG05, the OLE object still displayed the original file I created the OLE object with.
Any thoughts on how to do this please?
Cheers.
