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...

Yes, word and ppt will get included in the libraries as well. guessing a namespace of officeProducts,and a class for each product would suffice. Thanks for the heads up on the focus and cursor movement.

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...

Using KDiff3 which seems to work well for this case, but github will display "Binary file not shown." in the PR, so no diff is shown.

Cool, thanks for that info. Side note, did you need anything special in git "config" or "gitattributes" files for your diffs to not look all spaced out?

UCS-2LE The scripts are executed by HP's UFT, which is 16bit. The scripts are stored in GIT as UTF8. Perhaps I should just keep the language files stored in git under UTF16 (UCS-2) rather than in UTF8 and convert the file to UTF16 before execution? (I know it sounds odd, but trying to figure...

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...

Figured out the syntax, thx all! $body = @" { "name":"$($keyName[2])" } "@

I have the array, I am trying to write the items of the array to a JSON body for a REST API Call. Note: The array in an incoming Param to the powershell script. If the array has 3 items in it, John, Frank, Sam, and I just want John. The code below sends the name tag in JSON as "John Frank Doe...

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 =...

I wish it were, unfortunately, I can replicate the issue directly using manual steps as well. Seems like something hijack the controller.

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...

Would a possible solution to this be to write the shell scripts into the body of a VBScript, and then use schtasks to run it at a later time?

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...

Greetings all -- since it seems like no one has a solution that could solve this, I was forced to kick off a separate script at the point I needed to close excel. Set objExcel = GetObject(,"Excel.Application") objExcel.DisplayAlerts = FALSE objExcel.ActiveWorkbook.Close(FALSE)...

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...