READEXCEL problem in MC15

[Raiko]

Hi folks,

I have an Excel file consisting of 26 work sheets full of data. With the READEXCEL command I'd like to read them in, however:

1. READEXCEL doesn't read all the work sheets, but from 0 through 8
   
2. However, backwards I'm able to read from 26 through 10
   

I have checked whether there are some format problems on the sheet 9 or 10 but to no avail. This really puzzles me. Is there some kind of bug or does anybody see a flaw in the attached MC15 file?

Sorry, but it has to be in MC15 otherwise the READEXCEL command doesn't execute.

Thanks in advance

Raiko

[MikeArmstrong · Accepted solution]

It's because you have called your sheet ch 9 - CH 9.

Change it and it works.

Mike

[Raiko]

Thank you Mike. Must have been a case of code blindness-the weekend is nearing

Raiko

[MikeArmstrong]

Thank you Mike. Must have been a case of code blindness-the weekend is nearing

Not a problem.

Took me a while to spot it. As you said, its nearly the weekend

Mike