Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. ...
  2. Workbooks(CurrFile).Activate
  3. Worksheets(CurrHosp).Range("A1").Select
  4. Selection.PasteSpecial xlPasteValues
  5. TimeStamp = Now()
  6. ActiveSheet.Range("A5").Value = TimeStamp
  7. ActiveSheet.Range("A1").Select
  8.  
  9. Workbooks(ModelFile).Close SaveChanges:=False
  10. Workbooks(CurrFile).Close SaveChanges:=True
  11.  
  12. MsgBox ("Destination Updated")
  13. Else
  14. MsgBox ("No Source File Selected")
  15. End If
  16.  
  17. Application.StatusBar = False
  18. Application.DisplayAlerts = True
  19. Application.ScreenUpdating = True
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement