A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
strExcelPath = "C:\myfiles\header.xls" Const ForReading = 1 Const ForWriting = 2 'Added to save changes without being prompted by Excel Const xlSaveChanges = 1 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:\myfiles\test.txt", ForReading) strContents = objFile.ReadAll objFile.Close strContents = Replace(strContents, "|", vbTab) Set objFile = objFSO.OpenTextFile("C:\myfiles\test.txt", ForWriting) objFile.Write strContents objFile.Close Set objExcel = CreateObject("Excel.Application") 'Add row here??? 'Shift all other values down Set objWorkbook = objExcel.Workbooks.Open("C:\myfiles\test.txt") objExcel.ActiveWorkbook.cells.addrow("1,1") objExcel.ActiveWorkbook.SaveAs strExcelPath objExcel.ActiveWorkbook.Close xlSaveChanges objExcel.Application.Quit WScript.Echo "The Upload is Complete"
|Automatically create a conditional formatting rule in all users' outlook in organization||4||133|
|Running VB/Batch script through Group policy||30||117|
|vbscript to installing all steps of softwares automatically||7||20|
|Limit the # times a macro code will run||14||50|