Article View: pl.comp.lang.vbasic
Article #212Re: help makra w Exscel
From: Kazimierz Osiński
Date: Wed, 26 Nov 1997 14:30
Date: Wed, 26 Nov 1997 14:30
14 lines
1166 bytes
1166 bytes
Metoda expression.Wait(Time) zatrzymuje makro na okreslony czas.
Przykłady zastosowania z help'a VB w excellu:
This example pauses a running macro until 6:23 P.M. today.
Application.Wait "18:23:00"
This example pauses a running macro for approximately 10 seconds.
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
Kazimierz Osiński
kaziko@cso.com.pl
Technical Details
Message-ID:
<65hbgs$t7a@h1.uw.edu.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!uw.edu.pl!newsReferences:
<65h7j9$fu8$1@sunsite.icm.edu.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!uw.edu.pl!news From: Kazimierz Osiński <kaziko@cso.com.pl> Newsgroups: pl.comp.lang.vbasic Subject: Re: help makra w Exscel Date: Wed, 26 Nov 1997 15:30:19 +0100 Organization: A poorly-installed usenet news reader Lines: 72 Message-ID: <65hbgs$t7a@h1.uw.edu.pl> References: <65h7j9$fu8$1@sunsite.icm.edu.pl> NNTP-Posting-Host: 195.116.14.19 Mime-Version: 1.0 X-Newsreader: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit