Using only VBScript, I can unhide the window: Set oShell = CreateObject("WScript.Shell") oShell.AppActivate "Data Management Report Oct2017-Mar2018.xlsx - Excel" oShell.SENDKEYS("%") oShell.SENDKEYS("O") oShell.SENDKEYS("H") oShell.SENDKEYS("U") oShell.SENDKEYS("{ENTER}") But putting it in Macro Sch...

This works, but it does not respond to the ENTER when the Unhide window pops up:
Setting Focus on the Unhide window is also not working.

I have used the "Send Keys To Object Wizard" with the cross which gave many different window names within Excel //GetWindowHandle>Data Management Report Oct2017-Mar2018.xlsx - Excel,hWndParent //FindObject>hWndParent,Edit,,1,hWnd,X1,Y1,X2,Y2,result //GetWindowHandle>Data Management Report Oct2017-Ma...

Thank you Marcus

I have this code: But it only works if there is either subtracting or diving, but not both.
(In dividing I have to remove the brackets also)

I figured out what the problem was, I'm pulling files from FTP server with FTPGetFile>IP,USER,PASS,21,c:\FTP\,/Documents/,*.zip,I But I had the switch at the end set to A which resulted in corrupt zip files being transferred & when changing this to I meaning Passive Mode it did not corrupt the files...

Looping through the files is also not unzipping although the message displays the correct path & name: What does filespec mean ? - have tried many different filespec like *.xslx *.* but nothing works GetFileList>c:\FTP\*.zip,strFileList,; Separate>strFileList,;,file_names if>file_names_count=0 Input...

Hi There,

I'm trying to extract a zipped file from "C:\FTP" which name that is not constant to "C:\FTP\Unzipped\", but it is not unzipping it - please help?

The zipped file contains an xlsx file.

Trying to detect sound in "Volume Mixer" from specific application, when there is sound, the sound bar in windows 10 will move up & down according to sound played in the app, but I do not want the window to be visible as it is annoying when on screen. "Volume Mixer" is run by with the "sndvol.exe" f...

You can use this site that gives true random numbers from atmospheric noise - they have an API (not tested):
https://api.random.org/json-rpc/1/