Call Shell(“notepad.exe “”filename with path”””, vbMaximizedFocus) Read more →
Month: March 2016
Write File from excel
Sub WriteFile() Dim strPath As String strPath = “C:\\temp\\” & “filename.txt” Dim fso As Object Set fso = CreateObject(“Scripting.FileSystemObject”) Dim oFile As Object Set oFile = fso.CreateTextFile(strPath) oFile.writeLine sInsert For i = 2 To 100 ‘#loopCount oFile.writeLine “pankaj” Next oFile.Close Set fso = Nothing Set oFile = Nothing MsgBox (“Done”) End Sub Read more →
list of filename
dir /b Read more →
How to re-position dialogbox
$(“#dialog”).dialog(“widget”).position({ my: ‘center’, at: ‘center’, of: window }); where windows is container of position Read more →