I have manually inserted this file “ABC.exe” as an Object in excel workbook in sheet name e.g “Board”.
In NameBox the Object has name Object 1 and in Formula Bar =EMBED("Packager Shell Object","")
I can manually right-click on the cited object and choose Copy and then Paste on a predefined folder without any issue or warning message.
I need to automate the process of (Copy and Paste) using VBA.
I tried to use built-in Macro recorder and it give me this code: