If you specify a local folder (eg C:\myFolder) then the macro will try to create the file on the local machine of the user. If this is what you try to do then the macro needs to have 'system access' and the user will get a popup when he opens the document if he wants to allow the macro to have system access.