Loading

How to Create a Hyperlink in Excel Spreadsheet…

Someone at the newsgroup asked this question. This is the VBScript that I wrote to accomplish this. Dim objExcel Set objExcel = WScript.CreateObject("Excel.Application") objExcel.Visible = TRUE objExcel.Workbooks.Open "C:\\bintest.xls" objExcel.Workbooks(1).Activate objExcel.Workbooks(1).Worksheets(1).Range("A1").Select Dim sLinkAddress sLinkAddress = "http://www.google.com"…

WMI script to find files last accessed on…

dtDate = "5/2/2005" strSearchFolder = "C:Windows" Set objFSO = CreateObject("Scripting.FileSystemObject") WScript.Echo "File(s) last accessed on: " & dtDate & " in: " & strSearchFolder EnumAndCheckFiles objFSO.GetFolder(strSearchFolder), dtDate Sub EnumAndCheckFiles(objFolder, dtDate) Set objFiles = objFolder.Files For…