Is there a way to get info from http://www.noaa.gov/ (the National Weather
Service) and automatically transfer the information into PowerPoint? Not
call a web browser with the site in a separate window from Powerpoint, but
to actually have a PowerPoint slide updated with information from the
website itself?

Thanks!

Thanks. That worked for the text files, but not for the images or movies. Is
there a way to do it for those as well?

Also, will the excel file update each time the slide is accessed in
PowerPoint? It's not much use if the file remains the same.

Thanks for your help, your pages were really informative.

On 8/29/03 9:38 PM, in article u9iPTdpbDHA.2904[at]TK2MSFTNGP11.phx.gbl, "Jim
Gordon" <goldkey74[at]hotmail.com> wrote:

> Hi
>
> I think you might be able to do this by choosing Insert > Object > Microsoft
> Excel Worksheet. Then in the Excel embedded workbook create a web query.
>
> The embedded Excel worksheet can be refreshed with data directly from the
> web site. Details about web queries are here:
> http://www.agentjim.com/MVP/Excel/ExcelHome.htm
>
> -Jim Gordon
> Mac MVP
>
> All responses should be made to this newsgroup within the same thread.
> Thanks.
>
> About Microsoft MVPs:
> http://www.mvps.org/
>
> Search for help with the free Google search Excel add-in:
> <http://www.rondebruin.nl/Google.htm>
>
> ----------
> In article <BB74580B.2881%jmcdonald[at]nyc.rr.com>, Jason McDonald
> <jmcdonald[at]nyc.rr.com> wrote:
>
>
>>
>> Is there a way to get info from http://www.noaa.gov/ (the National Weather
>> Service) and automatically transfer the information into PowerPoint? Not
>> call a web browser with the site in a separate window from Powerpoint, but
>> to actually have a PowerPoint slide updated with information from the
>> website itself?
>>
>> Thanks!
>>

Hi again,

Excel will display an external data toolbar when the selection cursor is in
a web query (if you turned it off, turn it on again in View > Toolbars).

There is a button on that toolbar that lets you control when and how the
query will be refreshed. You will probably need to double-click the embedded
workbook to get the query refresh to occur.

If you want to get more than tabular data you'll need to use Internet
Explorer. On the IE favorites menu choose Subscribe then click Options.

Adjust the settings on the Schedule tab to establish a schedule to your
liking.

Click the Offline tab. Add a checkbox to "Download Site for Offline
browsing." then click Options and choose what web elements you want to
capture, and make a note of the file name and download location. Then Click
OK to save your settings.

In PowerPoint, select an object (a button, clip art, text box, etc) and then
use Insert > Hyperlink. On the Document tab click the Select button, then
navigate to the file that IE is using to subscribe to. The web page will
display in Internet Explorer, not PowerPoint, but I think that is as close
as you can get to accomplishing your goal.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
In article <BB7946C5.28EA%jmcdonald[at]nyc.rr.com>, Jason McDonald
<jmcdonald[at]nyc.rr.com> wrote:


>
> Thanks. That worked for the text files, but not for the images or movies. Is
> there a way to do it for those as well?
>
> Also, will the excel file update each time the slide is accessed in
> PowerPoint? It's not much use if the file remains the same.
>
> Thanks for your help, your pages were really informative.
>
> On 8/29/03 9:38 PM, in article u9iPTdpbDHA.2904[at]TK2MSFTNGP11.phx.gbl, "Jim
> Gordon" <goldkey74[at]hotmail.com> wrote:
>
>> Hi
>>
>> I think you might be able to do this by choosing Insert > Object > Microsoft
>> Excel Worksheet. Then in the Excel embedded workbook create a web query.
>>
>> The embedded Excel worksheet can be refreshed with data directly from the
>> web site. Details about web queries are here:
>> http://www.agentjim.com/MVP/Excel/ExcelHome.htm
>>
>> -Jim Gordon
>> Mac MVP
>>
>> All responses should be made to this newsgroup within the same thread.
>> Thanks.
>>
>> About Microsoft MVPs:
>> http://www.mvps.org/
>>
>> Search for help with the free Google search Excel add-in:
>> <http://www.rondebruin.nl/Google.htm>
>>
>> ----------
>> In article <BB74580B.2881%jmcdonald[at]nyc.rr.com>, Jason McDonald
>> <jmcdonald[at]nyc.rr.com> wrote:
>>
>>
>>>
>>> Is there a way to get info from http://www.noaa.gov/ (the National Weather
>>> Service) and automatically transfer the information into PowerPoint? Not
>>> call a web browser with the site in a separate window from Powerpoint, but
>>> to actually have a PowerPoint slide updated with information from the
>>> website itself?
>>>
>>> Thanks!
>>>
>
>