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.
But i now need to somehow do the same thing from notepad++ so i can call the script in a batch file later on.
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.