while 1 +1 after one loop is completed

[pezo89]

Hello, i where just wondering what the command for loop + was again?

im currently reading info from a cell and posts it into word,

and im trying to have it go one cell down after each time the entire script is done.

also beeing able to have it set how many times it should loop

$sFilePath1 = @ScriptDir & "\Jobber som skal søkes på.xlsx" ;This file should already exist
$oExcel = _ExcelBookOpen($sFilePath1)
$i =+1



$url = _ExcelReadCell($oExcel, 1+$i, 7);Første URL
$stillingstype = _ExcelReadCell($oExcel, 1+$i, 8);FørsteFørsteStillingstype

and so on, so say that i on start a script with an input bar, and inputs the number 3 and it loops it 3 times, and also on the end of each loop it goes one cell down.

[AdmiralAlkex]

A For-loop?

From helpfile:

For $i = 5 to 1 Step -1
    MsgBox(0, "Count down!", $i)
Next
MsgBox(0,"", "Blast Off!")

[pezo89]

A For-loop?

From helpfile:

For $i = 5 to 1 Step -1
    MsgBox(0, "Count down!", $i)
Next
MsgBox(0,"", "Blast Off!")

yes something like that. but how can i set the "timer" myself, with an inputbox?

[pezo89]

yes something like that. but how can i set the "timer" myself, with an inputbox?

nvm figuered it out. thanks alot

$o =+ InputBox("Test","Test","2")
For $i =+$o to 1 Step -1
    MsgBox(0, "Count down!", $i)
Next
MsgBox(0,"", "Blast Off!")

[AdmiralAlkex]

Those plus+sings doesn't look right

[kaotkbliss]

should be += shouldn't it?

[AdmiralAlkex]

Then I must be missing something.

$o = InputBox("Test","Test","2")
For $i = 1 to $o
    MsgBox(0, "Count down!", $i)
Next
MsgBox(0,"", "Blast Off!")

That's how I imagine what pezo wants.

[kaotkbliss]

$o =+ InputBox("Test","Test","2")

oh... hahaha

[czardas]

Just to clarify:

$o =+1 sets $o equal to 1 (the + sign is not needed => $o = 1)

$o =-1 sets $o equal to -1

$o += 1 (increments the value of $o by one)

$o -= 1 (decreases the value of $o by one)

[trancexx]

Just to clarify:

$o =+1 sets $o equal to 1 (the + sign is not needed => $o = 1)

$o =-1 sets $o equal to -1

$o += 1 (increments the value of $o by one)

$o -= 1 (decreases the value of $o by one)

And /= does that other thing and *= other other.

Btw, what's $o here?

$o =+-+-+-+-+-++++++++++-----------------------++-+ 8

[czardas]

And /= does that other thing and *= other other.

Btw, what's $o here?

$o =+-+-+-+-+-++++++++++-----------------------++-+ 8

I have no idea. Somehow I don't think it's +-+-+-+-+-++++++++++-----------------------++-+ message box.

[pezo89]

ahh i see.. thanks alot for the help fellas

[kaotkbliss]

Btw, what's $o here?

$o =+-+-+-+-+-++++++++++-----------------------++-+ 8

my guess is -8 (because there are more - than +)

*and after entering that line into a script and inserting a msgbox to display the result... I was right

[Tvern]

Actually it's negative because there is an uneven amount of negatives. The plusses do nothing.

+8 = 8

+-8 = -8

--8 = 8

---8 = -8

+++++++++++++++++++++++++++-8 = 8

etc.

[kaotkbliss]

run this code and see what you get...

$o =+-+-+-+-+-++++++++++-----------------------++-+ 8

MsgBox(0,"",$o)

*edit*

wait a sec, my answer was -8 and you said "actually it's negative..."

same answer.

Edited December 2, 2010 by kaotkbliss

[Tvern]

Actually it's negative because......

was a response to

(because there are more - than +)

Your answer was right, but the reasoning wasn't.

[kaotkbliss]

doh

(basic math fail)