Hi All
The concept is that as I send out new versions of the tool, users will be able to import the records they have been working on, and that is confined to the "records" sheet, so ideally they would overwrite the whole "records" sheet from a previous file to the new one, through a prompted macro.
I have this issue where I need to import from a user selected workbook a specific sheet to the workbook the macro is being run from.
The reason is that I would like the code not to open the target file, because if I do, the file in question will automatically start its own macro and that will break the flow.
...
Any advice?
The concept is that as I send out new versions of the tool, users will be able to import the records they have been working on, and that is confined to the "records" sheet, so ideally they would overwrite the whole "records" sheet from a previous file to the new one, through a prompted macro.
I have this issue where I need to import from a user selected workbook a specific sheet to the workbook the macro is being run from.
The reason is that I would like the code not to open the target file, because if I do, the file in question will automatically start its own macro and that will break the flow.
...
Any advice?