while 1 +1 after one loop is completed

[pezo89 2]

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 125]

A For-loop?

From helpfile:

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

[pezo89 2]

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 2]

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 125]

Those plus+sings doesn't look right

[kaotkbliss 146]

should be += shouldn't it?

[AdmiralAlkex 125]

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 146]

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

oh... hahaha

[czardas 1,269]

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 1,013]

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 1,269]

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 2]

ahh i see.. thanks alot for the help fellas

[kaotkbliss 146]

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 11]

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 146]

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 11]

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

was a response to

(because there are more - than +)

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

[kaotkbliss 146]

doh

(basic math fail)