Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub StartExtract()
- ' Load the CSV file
- OpenCSVFile
- Sheets("temp").Select
- Sheets("NS_Aug_310_330").Select
- Columns("A:F").Select
- Selection.ClearContents
- Workbooks.Open FileName:="C:Usersp100789DocumentsSAPSAP
- GUItext.txt"
- Cells.ClearContents
- ActiveWorkbook.Close SaveChanges:=True
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement