VBA Excel OpenDialogBox then Transfer the information to Sheet

Hi 😜 Hello, when I incorporate this code as an add-in within Excel, the data doesn't transfer to cells B12, B14, and B16 as expected. However, when I place the code in a module within the workbook itself, it works correctly.

1. Prompt the user to select an Excel file using the file dialog box.
2. Open the selected Excel file.
3. Retrieve the file location, file name, and the name of the first sheet in the Excel file.
4. Place this information in specific cells of a worksheet (Sheet3 using codename).
5. Close the selected workbook and quit Excel.
6. Display a message box informing the user that the process is complete.

Thank you 🙏

Please Login or Register  to view this content.

Also tried this code but no luck

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I assigned the add-in to a button on my ribbon. Then I clicked that button, and it returned the information that was expected, using this code:

Please Login or Register  to view this content.

Writing:

Please Login or Register  to view this content.

you are referring to the sheet with the code name Sheet3 in the workbook from which this code was run (that is, from the add-in). Wanting to find a sheet with a specific code name, you unfortunately have to create a loop through the sheets and look for the right one. If you knew the name of the sheet (the one shown on the tab), you could refer to it by:

Please Login or Register  to view this content.

Since you only know (you're sure) the code name, then, as I mentioned, only through the loop.

Please Login or Register  to view this content.

But I am not convinced that a separate instance of Excel should be used for this task. It seems enough to do it in the same instance.

Artik