Earlier, I received this code to copy a file to another directory. Works perfectly !
const SAVE_FILE_NAME as String = "K:\Persoonlijk\Breemes HRM\Public\Verlofplanner\file name here.xlsm"
If dir(SAVE_FILE_NAME) <> vbnullstring then kill SAVE_FILE_NAME
thisworkbook.savecopyas SAVE_FILE_NAME
I now wish to go further :
ON TOP OF THIS, I also which to copy the same file to yet another folder AND remove some sheets in this new copy (in other words : only copy one sheet of the file).
What the copying itself is concerned, I already discovered that just copying the above code is not good, it reports an error, seems that it seems to perceive it as a double instruction, which makes sense.
Bookmarks