Web query application - downloading ".shtml" web page to excel workbook

[Patrick]

I am unable to download ".shtml" web page using the following web
query text. I would welcome advice if the query needs to be modified.

WEB
1

http://home.datacomm.ch/rschaer/lotto/Z2004.shtml

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

In advance, thank you.

Patrick

 

[Jim Gordon MVP]

Hi Patrick,

If Excel crashed when you tried, then this is a bug in the 10.1.5 revision.
Please report it to Microsoft using the feedback feature on Excel's help
menu.

If something else happened, please post back with the version of Excel you
used.

Thanks.

-Jim

 

[Patrick]

Hello Jim,

Thank you for your speedy reply.

No excel doesn't crash, but when I run the web query using the excel
menu i.e: get external data>run saved query, the computer is working
for a few seconds, but the workbook used for the query is staying
blank. Running the query a second time, a message window comes up and
say: "the data cannot be downloaded from the requested address".

Now, when I run one one of the query template provided by Microsoft in
Office>Queries, the database is downloaded without any problem and
updated each time I open the workbook.

The working query is:

WEB
1

http://moneycentral.msn.com/investor/external/excel/rates.asp

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False


Reading various articles on the web, I understand that ".shtml" web
pages are different than a standard .html page and therefore need to
be treated differently when one want to download such pages. The thing
is, I don't know how to modify the query accordingly?
So, if you could help on this issue, I would be very grateful.

Best.

Patrick.

 

[JE McGimpsey]

No excel doesn't crash, but when I run the web query using the excel

menu i.e: get external data>run saved query, the computer is working
for a few seconds, but the workbook used for the query is staying
blank. Running the query a second time, a message window comes up and
say: "the data cannot be downloaded from the requested address".

Now, when I run one one of the query template provided by Microsoft in
Office>Queries, the database is downloaded without any problem and
updated each time I open the workbook.

The working query is:

WEB
1

http://moneycentral.msn.com/investor/external/excel/rates.asp

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False


Reading various articles on the web, I understand that ".shtml" web
pages are different than a standard .html page and therefore need to
be treated differently when one want to download such pages. The thing
is, I don't know how to modify the query accordingly?
So, if you could help on this issue, I would be very grateful.[/QUOTE]

Your query worked for me as written after removing the line between "1"
and "http://..."

 

[Jim Gordon MVP]

Hi Patrick,

It should make no difference whether it is secure or not. The query ought to
work. I suspect that it's the updated version of XL causing the problem. A
web query bug was inadvertently introduced into the latest update. Previous
updates will probably work OK.

-Jim

 

[Patrick]

Hi Patrick,

It should make no difference whether it is secure or not. The query ought to
work. I suspect that it's the updated version of XL causing the problem. A
web query bug was inadvertently introduced into the latest update. Previous
updates will probably work OK.

-Jim

Hi Jim!

The "shtml" web page doesn't stand for secure like "https". It stands
for Server Side Includes (SSI) used by webmaster to parse dynamically
web pages. Please refer to the following page for info:
http://httpd.apache.org/docs/howto/ssi.html#whataressi

When you say "updated XL version". Do you refer to Windows ? I am
personally running excel on a iMac with Panther OS.

If you have time, I would suggest you try to run the two queries text
I have posted previously and see what you get.

N.B: the two queries have exaclty the same text instructions except
the web address.

Thank you and best regards.

Patrick

 

[Patrick]

Hello Jim !
..shtml web page doesn't stand for secure like https, it refers to
server side includes technology where the server is dynamically
parsing web pages, see following web page for more info:

http://httpd.apache.org/docs/howto/ssi.html#whataressi

When you refer to: XL updated version, do you mean Windows software? I
am running on MacOS 10.3 (Phanther) and have downloading the Microsoft
Queries Application for Mac to get external database.

If you are also running on Mac and have some time to spare, I suggest
you run the two query text I posted earlier on. Please also note that
both query texts instructions are identical, except for the web
address. In my opinion, to download external database from a (ssi)
server, one needs to adjust the query instructions accordingly.

Kind regards,

Patrick.

 

[JE McGimpsey]

Hi Jim!

The "shtml" web page doesn't stand for secure like "https". It stands
for Server Side Includes (SSI) used by webmaster to parse dynamically
web pages. Please refer to the following page for info:
http://httpd.apache.org/docs/howto/ssi.html#whataressi

When you say "updated XL version". Do you refer to Windows ? I am
personally running excel on a iMac with Panther OS.

If you have time, I would suggest you try to run the two queries text
I have posted previously and see what you get.

N.B: the two queries have exaclty the same text instructions except
the web address.

Thank you and best regards.

And I still say I can download the page using the listed with XL 10.1.5,
as long as the line between 1 and the URI is deleted.

Does that not work for you? In that case, there might be something going
on at the operating system/network level, rather than XL.

 

[Jim Gordon MVP]

Hi Patrick,

Sorry for being asleep about the protocol.

I was able to run the query after removing the extra line between the 1 and
the URL in Excel 2001. Excel version X with the 10.1.5 update crashes for
me.

-Jim

 

[Patrick]

Hello Jim,
Thank you for trying. I will check again with Apple and Microsoft and
see what they say regarding the crash of version 10.1.5.
Will let you know.

Best.

Patrick