copy a docm-file from a fixed folder location into the folder of the currently active workbook using VBA
I would like to copy a Word-File named 'TecDataSheet.docm' from 'M:\General\MyFolder\TecDataSheet.docm' into the folder of the currently open excel file.
That is …
… if the excel file from which the macro is activated, happens to reside in the folder C:\MyDocuments\.. the macro has to copy the above file (TecDataSheet.docm) from M:\General\MyFolder\TecDataSheet.docm into this folder (C:\MyDocuments\..)
Help is much appreciated. Thank you very much in advance. Regards, Andreas