Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Filling_List()
- Dim sPath As String, sFile As String, wb As Workbook, i As Integer
- 'Application.ScreenUpdating = False
- sPath = "C:UsersaricsonpDesktopFilling list macro"
- sFile = sPath & "ArF Filling List.xlsm"
- Set wb = Workbooks.Open(sFile)
- ActiveSheet.Copy After:=Worksheets(Worksheets.Count)
- Worksheets(Worksheets.Count).Name = InputBox("New Name:")
- If sName = "" Then Exit Sub
- ActiveSheet.cell(3, "E") = InputBox("Your Name:")
- ' With ActiveSheet.Sheets("ArF Filling List (7)")
- '.Range("B03").Value = uploader.Sheets("Que & Tsc Cal").Range("B02").Value
- ' .Range("B05").Value = uploader.Sheets("Que & Tsc Cal").Range("B01").Value
- ' End With
- 'Application.ScreenUpdating = True
- End Sub
Add Comment
Please, Sign In to add comment