cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

READEXCEL problem in MC15

Raiko
16-Pearl

READEXCEL problem in MC15

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

1 ACCEPTED SOLUTION

Accepted Solutions
MikeArmstrong
5-Regular Member
(To:Raiko)

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

Change it and it works.

Mike

View solution in original post

3 REPLIES 3
MikeArmstrong
5-Regular Member
(To:Raiko)

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

Change it and it works.

Mike

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

Raiko

MikeArmstrong
5-Regular Member
(To:Raiko)

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

Top Tags