Skip to main content
R
Raiko17-Peridot
17-Peridot
November 4, 2010
Solved

READEXCEL problem in MC15

  • November 4, 2010
  • 1 reply
  • 3844 views

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

Best answer by MikeArmstrong

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

Change it and it works.

Mike

1 reply

M
MikeArmstrong1-VisitorAnswer
1-Visitor
November 4, 2010

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

Change it and it works.

Mike

R
Raiko17-PeridotAuthor
17-Peridot
November 4, 2010

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

Raiko

M
MikeArmstrong1-Visitor
1-Visitor
November 4, 2010

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

Terms & ConditionsCookie settingsAccessibility statement