I have a macro that prompts the user to open an excel file. The chosen file gets copied into the current workbook.
My question is:Is it possible to write a code that copies the file name that was chosen and paste it in a cell of the workbook that is already opened?
My question is:Is it possible to write a code that copies the file name that was chosen and paste it in a cell of the workbook that is already opened?