|
PureBytes Links
Trading Reference Links
|
Next up I am asuming your "system test" to be a VBA macro
or at least includes a macro for use in Excel. From the below
description of VB's DATE data type youcan see what and what
actions you can perform and what for consequences/impact
just an simple Excel macro can have on one's computer.
Rest asured that not exchanging the physical worksheets/workbooks
will prefent any accidents/virusses to enter your PC or be spread
around the globe. Eg exchange the code alone, please!
============================================
Now, tho you are in Excel, one of its additional features is the
build-in VBA program.
VBA is much like VB (+ some added features).
The basics of VB is to perform tasks. One of the tasks can be
to "Work with Dates and Times". The DATE data type makes it
easy to work with dates and times. Dates are double precission
numbers. The whole part of the number represents the date, and
the fractional part represents the time.
For example, the following code displays tomorrow's date:
MsgBox "Tomorrow is " & DateValue(Now + 1)
Similarly, the following code sets the system clock back one hour:
Time = Timevalue(Now - 1/24)
Visual Basic provides a number of functions and statements for
working with dates and times, as (partly) shown in table below.
At the moment there are 3
"Date and Time Functions and Statements" categories:
Current
Date manipulation
Time manipulation
In the category "Current" you will find 4 functions/commands, eg:
Category Function or Statement Task
------------- ------------------------------ -------
Current Date Sets or returns the system date
Now Returns the current date and time
Time Sets or returns the system time
Timer Returns the number of seconds since
midnight (used for timing processes)
The other categories "Date manipulation" and "Time manipulation"
will only "return" values (like the above "Now").
Any VB compatible program, f.i. VBA in Excel, can then retrieve and use
these values, eg they can than be used for "further molding and manipulating"
to fit your needs and for example be Pasted in the Worksheets Cells.
===========================================
Excerpts from the book:
Using Excel Visual Basic
for applications Second Edition (Special Edition)
by Jeff Webb (formely Senior member of the BASIC team at Microsoft and
now running Wombat Technology, Seattle, WA)
Publisher : QUE Corp.
ISBN : 0-7897-0269-x
I am sure you will find the electronic version of the book very intresting
http://www.informit.com/product/078970269X/
(thanks to Daniel Martinez for the "publishers" hangout link)
If you have any questions on VBA for Excel, you can go to this newsgroup
news://msnews.microsoft.com/microsoft.public.excel.programming
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying and
note the new address change. Also for my Homepage
http://home.planet.nl/~anthmaas
----- Original Message -----
From: A.J. Maas
To: <metastock@xxxxxxxxxxxxx>
Sent: zondag 9 januari 2000 11:58
Subject: Re: how to improve generalization in system optimization
> -I forgot to mention that the Windows clock can also be accessed
> through right clicking.
> -The Dos clock is not visable to user, eg it can only be "accessed"
> via the common DOS commands run from the DOS prompt.
>
> Please provide more information. Please be more precise and precise in detail.
> Describe better all your actions, program details and file details.
>
---------snip------------------
|