Guest User

Untitled

a guest
Nov 17th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. Sub Filling_List()
  2. Dim sPath As String, sFile As String, wb As Workbook, i As Integer
  3.  
  4. 'Application.ScreenUpdating = False
  5.  
  6. sPath = "C:UsersaricsonpDesktopFilling list macro"
  7. sFile = sPath & "ArF Filling List.xlsm"
  8.  
  9. Set wb = Workbooks.Open(sFile)
  10.  
  11. ActiveSheet.Copy After:=Worksheets(Worksheets.Count)
  12. Worksheets(Worksheets.Count).Name = InputBox("New Name:")
  13. If sName = "" Then Exit Sub
  14.  
  15. ActiveSheet.cell(3, "E") = InputBox("Your Name:")
  16.  
  17. ' With ActiveSheet.Sheets("ArF Filling List (7)")
  18. '.Range("B03").Value = uploader.Sheets("Que & Tsc Cal").Range("B02").Value
  19. ' .Range("B05").Value = uploader.Sheets("Que & Tsc Cal").Range("B01").Value
  20. ' End With
  21.  
  22.  
  23. 'Application.ScreenUpdating = True
  24.  
  25.  
  26. End Sub
Add Comment
Please, Sign In to add comment