#createtextfile

[akashchugh-blog]

how to create a text file in kali - using nano

http://www.techtrick.in/description/3472-how-to-create-a-text-file-in-kali-using-nano

[dontfretbrett-blog-blog]

Excel VBA - Copying a Workbook to a SharePoint site via Windows Scripting

I created this as a part of a macro that refreshes a report and posts it to our sharepoint site. I decided to go with Windows Scripting since it copies the file to SharePoint without lagging the workbook in the meantime. For the FileSystemObject set a reference (VBA Editor > Tools > References) to "Microsoft Scripting Runtime".

    Dim WB as Workbook: Set WB = ActiveWorkbook

    Dim FSO As New FileSystemObject

    Dim TS As TextStream: Set TS = FSO.CreateTextFile("c:\copy.bat", True)

    TS.WriteLine "@echo off"

    TS.WriteLine "echo Uploading " & WB.Name & " to Sharepoint"

    TS.WriteLine "copy " & Chr(34) & WB.fullName & Chr(34) & " " & Chr(34) & "\\sharepoint_site\Reports\" & WB.Name & Chr(34)

    TS.WriteLine "echo " & WB.Name & " successfully uploaded."

    TS.WriteLine "pause"

    TS.Close

    Dim SH As Object: Set SH = CreateObject("wscript.shell")

    SH.Run "c:\copy.bat"

    Set SH = Nothing