Ok so I'm new to VBS, and sorry in advance for the simple question :laugh: I'm in notepad++ and I need to remove the first two lines of a file and then save the file as a tab delimited value .txt file. The name of the file I'm using is Snowfall.xls I got this code to do work in the vba window from excel. Sub deleteMultipleRows() Rows("1:2").Delete End Sub Sub export() ActiveWorkbook.SaveAs Filename:= _ "c:\MyFile.csv", FileFormat:=xlCSV _ , CreateBackup:=False End Sub But i now need to somehow do the same thing from notepad++ so i can call the script in a batch file later on.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

vbs to delete rows

Thread starter Sonican
Start date Aug 2, 2016
Tags

delete notepad++ tab delimited

Sonican

New Member

Aug 2, 2016

Ok so I'm new to VBS, and sorry in advance for the simple question

I'm in notepad++ and I need to remove the first two lines of a file and then save the file as a tab delimited value .txt file.

The name of the file I'm using is Snowfall.xls

I got this code to do work in the vba window from excel.

Code:

Sub deleteMultipleRows()
Rows("1:2").Delete
End Sub




Sub export()
ActiveWorkbook.SaveAs Filename:= _
"c:\MyFile.csv", FileFormat:=xlCSV _
, CreateBackup:=False
End Sub

But i now need to somehow do the same thing from notepad++ so i can call the script in a batch file later on.