Could you help me.
I have some report and I need to Open csv/xls and than:
1. delete first row
2. delete some columns
3. add 3 kolumn names
Could you help me ? (it needs to be a function)
I now hot to do it in VBA but I don;t have idea how to to it in VBS
I Have some code:
Could you help me ?
Const ForReading = 1
Const ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\CSVFiles\Rapport.csv", ForReading)
Set objFile = objFSO.OpenTextFile("c:\CSVFiles\Text.csv", ForWriting)