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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Time difference in miliseconds
Hello, I have two cells in excel which I need to find the time difference between them in miliseconds: a = 2005-07-07 04:38:43.998 b = 2005-07-07 04:38:44.002 The answer should be: 4 How can I find it using vba code? I saw the "datedif" function but the units don't have milisecond option.. In...- EfratS
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
pop/push to array
Is there a convenient way to push/pop element to/from an array in vba? Thanks!- EfratS
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
query table structure
Hello all, What is the sql query for getting some table's structure? (field name, field type etc..) Thanks!- EfratS
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
compare hex variable to certain value
Hello, I'm trying to run the following code: $found = 0; $posCount = 0; while (!($found)){ $b = substr($callBuf, $posCount, 24); $data = unpack('H24',$b); if ($data == "0000001d0000000700000001"){ $found = 1; } else{ ++$posCount; } } $callBuf contains binary data that were... -
assign 2-dim array to other array - unclear behaviour
hello, I'm tring to assign 2-dim array to another array with the following code: @tmpArr = @originalArr; The unclear behaviour has been detected with this code: print "here: @{$originalArr[1]}\n"; ${$tmpArr[1]}[0] = 111; print "here: @{$originalArr[1]}\n"; The originalArr value in cell... -
-
Get the date of the day before
Hi, Is there a convinient way to get the privious date before any given date? example: the given date: 01/07/2004 the privious date: 30/06/2004 (the wanted output) Thanks. -
number of keys in a hash
Hi, how can I know the number of keys I have in a hash? Thanks. -
"mod" operation in perl
Hello, Does someone knows how can I implement the "mod" operation in perl? meaning: x= 5 mod 2 x = 1 thanks. -
Open web page with perl script
Hello, Does someone knows how can I simply run URL throw my perl code? To be more specific: I want that the last row in perl script will open the www.google.co.il web page, and then the script should be terminated. thanks.
