Search results for query: *

Is it possible to write script exactly in bytecode (I mean using characters with ASCII code less then 32). I know that perlcc -B can be used, but it generates bytecode with architecture information and such a code can't be executed on other computers with different compiled perl (for example...

I don't know... I haven't seen the code... BTW: We do not count characters with ASCII code less or equal to 32... I don't know if it makes much difference... Do you think it's impossible to do it in just 10 chars (with ASCII code>32)?

Thanks a lot... But now I have a real challange... We are given a set of numbers: x y_1 y_2 y_3 ... y_x y_x+1 y_x+2 ... y_n We have to write program that will read only x first values from the input and sum up only those which are greater then zero. For example: 5 4 3 -3 -1 4 -8 12 11 10 5 6...

And I'm also not allowed to use "-ln"...

I'm not allowed to use "-l"...

Hi, I'm learning Perl and for now I'm on regexp. With my friend, we make some challnages for shortest code. We have such a task: We are given some words (of length at most 20). These words are made only from capital letters (A..Z). We want to count and print out 2**(number of letters A,B,C,D)...

Of course you should also add to loop condition something like: Do x = InputBox( "Enter date", "Date" ) Loop While (x = False Or x = Empty Or Not IsDate(x))

Maybe you should try something like this: In your Worksheet_Change subroutine replace MsgBox with InputBox like this Dim x as Variant ... Do x = InputBox("Enter date", "Date") Loop While (x = False Or x = Empty) If user submits without entering anything x will be equal empty, if user...

I have three UserForms in my Excel VBA Application. First Form is to select files to compare, second is some kind of progress bar, and third is to show when duplicated cells are found - it should let users choose which value is correct. When first duplicated cell is found everything is ok - user...

I wonder if there is any way to manipulate strings in VBA just like it can be done in C/C++. I mean - is there any way to do something like accessing single letter with []? For example is there any way to check for example third letter in a word in C/C++ way (word[2])?

I decided to use a hidden column solution, so now there is no need to check what users are coping/pasting. Anyway it is nice to know that there is such a function in VBA (I don't have help files installed so actually it is really hard for me to check anything). Maybe I am wrong, but should any...

I have such problem: In a cell there is a formula with constant $J$<row>, where row changes for each 20 rows. When someone is coping/pating a row I want to check is thers this formula and if so I want to find proper row number and replace it in formula. I'm trying to use change property and I...

Hello! Is there any way to catch paste event in excel vba. I mean - I need to catch it, check if there is any dollar sign and if so change the address, otherwise paste it without changes. Any idea how to do it? Best regards, Tytus

You're right - but from the unknown reasons on 3 (from 4) of my worksheets it didn't work. But as they were very similar to each other I've just copied the correct one and now everything is ok. But still - I don't know why it wasn't working before. Best regards, Tytus

I wrote a macro to hide an empty rows - and it works ok, but when I want to print sheet with hidden rows, excel show (on printout preview) empty space - so even if I want to print only one row (from 40 I have) I get one row on first page, then empty space and last row (summary) on second page -...

Is there any way to recalculate fields inserted in header after the detail section has been calculated - I mean - if I would like to insert in header information about the number of records in details sections I need a way to calculate it at the end - when I'm just putting it in the report it...