Search results for query: *

dear PCLewis, This basic problem arouse when I've tried to implement rmikesmith's solution. I appriciate his effort very much, and his answer is very relevant to my problem - it just that I encounter another problem in the way. That was my intention. from your kind answer I now understand that...

First - thank you all for your answers. Zathras: I don't need to find the time difference between start to end, but between 2 given values from worksheet. rmikesmith and PCLewis: your ideas seem to be in the right direction, but I have a basic problem in putting the information from the...

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...

ok, let me rephrase my question: The size of my array is dynamic - it'll be changed during the running time: If certain condition is true - I want to add element to my array. If another condition is true - I want to remove the elements from the array in FIFO order until it'll be empty. The way...

Is there a convenient way to push/pop element to/from an array in vba? Thanks!

Hello all, What is the sql query for getting some table's structure? (field name, field type etc..) Thanks!

tried this also...doesn't work.

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...

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...

Hi, How can I sort hash by date? Thanks..

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.

Hi, how can I know the number of keys I have in a hash? Thanks.

Hello, Does someone knows how can I implement the "mod" operation in perl? meaning: x= 5 mod 2 x = 1 thanks.

When I'm trying to run your first suggestion, the following error message appears: "Undefined subroutine &main::redirect called" Do I need to insert any "use" ? Thanks!

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.