Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
xlsx splitter by rows
Hi Can a VBS script take an xlsx file that has more than 65000 rows and create as many target files whose rows number count do not exceed that? This script should work independent of Excel in windows xp. Thanks- drgt
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Send ALT + F4
@strongm Hmmm... I do not know. It works right now. Does not affect other chrome, or not, windows and as wise people have said, "If it is not broken, DO NOT fix it"! -
Send ALT + F4
Yes, thank you. (You should have stayed at the code and omit OS shutdown after prompt! :-)) -
Send ALT + F4
Figured it out. Set objShell = Wscript.CreateObject("Wscript.Shell") objshell.SendKeys "%{F4}" -
Send ALT + F4
taskkill terminates chrome alltogether. I want to close the window the "chrome.exe --app=..." just opened. That is why I want to send Alt + F4 -
Send ALT + F4
Up to this point ("C:\Program Files\Google\Chrome\Application\chrome.exe" --app=http://xxx.xxx.xxx.xxx/cm?cmnd=.....) it works fine. If I hit Alt + F4 manually the window closes. I just need the batch file to do it... -
Send ALT + F4
Thanks for the answer. Let me be more specific. I am trying to make a batch file that when executed: 1. Would open a chrome window and get an http address: "C:\Program Files\Google\Chrome\Application\chrome.exe" --app=http://xxx.xxx.xxx.xxx/cm?cmnd=..... 2. Would then close that window 3. Would... -
Send ALT + F4
Used Windows notepad, typed Sendkeys "%{f4}" and saved the file with vbs extension. However, when executing, I get: Windows Script Host Script: C:\test.vbs Line: 1 Char: 1 Error: Type mismatch: 'Sendkeys' Code: 800A000D Source: Microsoft VBScript runtime error What am I doing wrong? Win XP...
