Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Course Of The Month
8 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
WScript Shell Popup / WScript Echo - How to Pop Message That Disappars
Posted on 2011-02-26
I'm hacking together a .vbs that converts a series of .csv to .tsv
I need it to do a pop-up or other message telling me which file it is up to.
I've tried these:
set WshShell = CreateObject("WScript.Shel
Result = WshShell.Popup("Converting
... and ...
wscript.echo("Hello")
But I get a Pop-Up where it waits for me to hit OK
I don't want it to wait - I just want it to say the message and then disappear by itself. Waiting for the OK also holds up the script, so if I have to process a batch of 100 files, someone has to sit there and keep hitting OK
I can run without a status, but then I don't know what it is doing....
Thanks
I need it to do a pop-up or other message telling me which file it is up to.
I've tried these:
set WshShell = CreateObject("WScript.Shel
Result = WshShell.Popup("Converting
... and ...
wscript.echo("Hello")
But I get a Pop-Up where it waits for me to hit OK
I don't want it to wait - I just want it to say the message and then disappear by itself. Waiting for the OK also holds up the script, so if I have to process a batch of 100 files, someone has to sit there and keep hitting OK
I can run without a status, but then I don't know what it is doing....
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
2- +1
10 Comments
Actually the example in your question would work the second parameter is the amount of times in seconds to wait.. so eventually if you waited three seconds it would go away by itself. However you probrably want something better.. You could have your script create a blank page resize it the page small and write the current file as HTML then close the window upon next entry.
Popup Method
http://msdn.microsoft.com/en-us/library/x83z1d9f(v=vs.85).aspx
Popup Method
http://msdn.microsoft.com/en-us/library/x83z1d9f(v=vs.85).aspx
Active today
See if this gives you some ideas...
Set objExplorer = WScript.CreateObject("InternetExplorer.Application","IE_")
objExplorer.Navigate "about:blank"
objExplorer.ToolBar = 0
objExplorer.StatusBar = 0
objExplorer.Width=400
objExplorer.Height = 100
objExplorer.Left = 0
objExplorer.Top = 0
objExplorer.Visible = 1
objExplorer.Document.Body.scroll = "no"
For i = 1 to 5
objExplorer.Document.Body.InnerHTML = "Test message #" & i
wscript.sleep(1000)
Next
objExplorer.Quit
Elq1044 - I agree it "should" work but it doesn't. I put in a 3 second delay and it never continues until I hit OK. I don't know if this is a Windows 7 thing or not.
Billprew - will test and post back. Thanks
Billprew - will test and post back. Thanks
Worked great, thanks. You've given me an idea to add several more indicators.
If you know ... I'm processing through a CSV file that's been read in. I want to count up the number of rows read in from the file. While I can do this (below) it is slow with 1 million rows. Is there a built in attribute / etc. that I can just reference that already knows the number of rows in the stream?
Thanks
' Count the number of rows
rowcount = 0
Do Until objFile.AtEndOfStream
strLine = objFile.ReadLine
rowcount = rowcount + 1
Loop
objExplorer.Document.Body.
wscript.sleep(1000)
If you know ... I'm processing through a CSV file that's been read in. I want to count up the number of rows read in from the file. While I can do this (below) it is slow with 1 million rows. Is there a built in attribute / etc. that I can just reference that already knows the number of rows in the stream?
Thanks
' Count the number of rows
rowcount = 0
Do Until objFile.AtEndOfStream
strLine = objFile.ReadLine
rowcount = rowcount + 1
Loop
objExplorer.Document.Body.
wscript.sleep(1000)
Active today
No, nothing built-in. The issue is that you need to read the whole file (stream) to know how many rows it contains.
Active today
While the IE approach showing a updating web page is a good idea, and allows for some GUI tricks like a progress bar, I would be more inclined to use a real Windows Form object for that. However, my personal approach for logging or showing progress is to use the console (cscript), and just echo there (WSript.Echo or WScript.StdOut.Write - the latter errors with wscript, but allows for writing into the same line when used with cscript).
Active today
Instead of using the number of lines as progress indicator you could use the number of bytes, objFile.size, and count the bytes you already read.
Active today
==> Instead of using the number of lines as progress indicator you could use the number of bytes,
==> objFile.size, and count the bytes you already read.
+1 on this, I was just about to post this (versus number of lines) when I saw that Qlemo mentioned it. There is an attribute that you can query on the file object to get the size of the file without reading it in, and then as you process each line you can add the length of that line to an accumulator of bytes processed, and compared total bytes to calc progress.
~bp
==> objFile.size, and count the bytes you already read.
+1 on this, I was just about to post this (versus number of lines) when I saw that Qlemo mentioned it. There is an attribute that you can query on the file object to get the size of the file without reading it in, and then as you process each line you can add the length of that line to an accumulator of bytes processed, and compared total bytes to calc progress.
~bp
If you use the byte approach you will have to consider extra bytes that won't be picked up like line feeds which could be two extra bytes per line, one million lines without accounting for line feeds would give you an unpredictable percentage value.
Featured Post
Are you interested in becoming an AWS Certified Solutions Architect?
Discover a new interactive way of training for the exam.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Learn the basics of lists in Python.
Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 1 hour left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.