Steve,
If you're still here...
Yesterday i tried running the code on a file at my work. I kept on getting a message that the file was an unexpected format.
It took me a while before i realized that it was an excel generated by Hyperion.
When i copied it, and pasted values into a new book, the problem was solved.
Maybe something simular to what you experienced?

Gert Jan