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

READEXCEL problem in MC15

SOLVED
Highlighted
Amethyst

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

Re: READEXCEL problem in MC15

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

Change it and it works.

Mike

3 REPLIES 3

Re: READEXCEL problem in MC15

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

Change it and it works.

Mike

Re: READEXCEL problem in MC15

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

Raiko

Re: READEXCEL problem in MC15

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