Loop problem

[HeHeHaHa]

Hi guys,

I wanted to do a vba loop where it writes

20141101000000 which reads as [year][month][date] and time [24 hour format for every 3 hour]
20141101030000
20141101060000

I wanted to stop my inner loop at 21000 hour and the bigger loop at 20141130

here is how i write my code

Please Login or Register  to view this content.

but here is the result

201411010
2014110130000
2014110160000
2014110190000
20141101120000
20141101150000
20141101180000
20141101210000

the bigger loop doest work
and how do i show the 1st row do have another 4 zeroes?

Thanks

[karedog]

Hi,

You must reset the value of "Time" variable before you use it again for the next inner loop.
If you don't reset it, after the first inner loop, the "Time" variable value is always 210000, so the next loop will always be skipped.

Please Login or Register  to view this content.

To set the desired text format for the "Time", use the format() function like in above code.

And I suggest, please do not use reserved keywords (like Month and Time) as variable name, it can give a lot of trouble.
Change them to something like TheMonth, TheTime.

Regards

[mehmetcik]

Please Login or Register  to view this content.