Search results for query: *

On windows 7, 8, 10, 2012 Event ID 2013 Does not show up real time or at all. [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanServer\Parameters] for "DiskSpaceThreshold" & "LowDiskSpaceMinimum" set to 10% and 10 GB Rebooted after adding those keys Filled disk up to a couple GB left...

I have a ton of Utility classes in vbscript, ie excelUtils would have methods such as isRowEmpty and gotoCell Public Sub isRowEmpty (byval iRow) Dim xlObj : set xlObj = eval("getobject(,""Excel.Application"")") Dim actWS : Set actWS = xlObj.ActiveWorkbook.ActiveSheet cell = "A" & iRow...

I Have a bunch of vbs files that are in the UTF8 format stored in Github. When adding files to github, all the encoding is committed in UTF8, however, I am working with languages, and some of the arrays are in other languages, requiring UTF16 encoding. Does it makes sense to check this in as...

Hi all, I am new to this and not 100% sure on syntax, what I am trying to do this $body = @" { "name":"keyName[0]" } "@ but this seems to send all the items within keyName and [0] as the last item within the request, rather than just the first item. What am I missing? thanks in advance!

Hi All - This is in vbscript and not VBA, but figured the VBA MSFT community might have an answer/explanation of this. What is the difference between these two methods of getting a currently running Excel process? Set objExcel = GetObject( , "Excel.Application") vs. Set objExcel =...

Hi all, Having a little issue with Windows Task Manager. Generally, we have automated scripts that will open Windows Task Manager, Find the Application it's looking for, then Click "Switch To" to make that application the active window. However, in some/many cases, with multiple windows...

hi all, got a small problem trying to determine where office is installed in my vbs. I have a vbs that will open office products, excel.exe for example, and it will take a version as well (multple office suites are installed 03, 07, 10, 13). On an XP machine, normally it's in C:\Program...

I've gone to Excel Options -> Save -> and unchecked Save AutRecover information every... and Unchecked Disable AUtoRecover for this workbook only. However, When I open MyFile.xlsm, I still get a ~$MyFile file along side it. Should this have stopped after disabling the options? I even...

Hi, I am looking to run 1 or more tasks from a User Form interaction that will run either now, or at a specified time. I'm not sure the onTime facitlity will work for this. For immediate run, I have code that contains: Set objShell(x) = CreateObject("wscript.shell") For x = 0 To numShells...

Hi, my first post, I am trying to get a script together that will Open an 03, 07 or 10 excel application, all on the same PC, passing into the script file and version. Then I perform some operations and leave it open so another automation tool may interact with it and closed the app ala Alt-F4...