I don't understand it either :-S

I'm just using Application.Workbooks.Open("url")

s.

"William Benson" wrote:

I wonder why Outlook and exchange know to rename a open file with a (1)
after the name -- Book1 becomes Book1(1) when opened again-- but the
method you are using won't.


"stevefromoz" wrote in message
...
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