Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. Dim OrigName As String
  2. Dim FolderPath As String
  3.  
  4. OrigName = ActiveWorkbook.FullName
  5. FolderPath = "\MappedDriveFolder1Folder2"
  6.  
  7. If Dir(FolderPath, vbDirectory) <> vbNullString Then
  8. ActiveWorkbook.SaveAs FolderPath + ActiveWorkbook.Name
  9. ActiveWorkbook.SaveAs OrigName
  10.  
  11. Else
  12. Exit Sub
  13. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement