Hi Peter,

Did you ever find a solution to this problem? I'm wanting to do the same
thing (basically load a file from a stream) but can't find any references to
doing this.

Not sure if you ran into this as well, but I am trying to open files from a
web server, which works fine, but if I try to open 1 file, it doesn't work
as the file names take on the name of the server, and you can't open 1 file
with the same name.

For e.g. you go File|open "http://myweb.com/somefile.aspx", assuming the
aspx returns an output type (MIME type) of excel, this will open fine, will
be read-only and will be called 'myweb'. If you then try to open
"http://myweb.com/someotherfile.aspx", this fails because excel wants to name
the file 'myweb' but can't as there's already a file there called that. How
can we change the filename without having to save it to disk, and preferably
in code.

Any takers?!?!

"Peter Hurford" wrote:

I have a program which has an xsl file sitting in a blob of memory.

I want to use the Excel object model to load up the blob, and to read
the rows/columns etc.

Is there any way to do this *without* having to save my blob to a file
on the hdd first? I would like to keep everything in memory if
possible, since once the blob has been processed, it is discarded.

TIA,
Pete