[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: XL 2000



PureBytes Links

Trading Reference Links

Walter:

This sounds great.  Will XL2000 run under WIN 98?

Lionel
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, August 17, 1999 11:26 AM
Subject: XL 2000


>
> Of interest in the new Excel 2000 is the new "retrieve data from a web
page"
> wizard. All that free data and now a very, very easy way to get it.
>
> The wizard is very straight forward. No more programming and ".igy's",
all
> you do is enter the address of the site. (It includes a browser button
for
> easy access for those like me, who can't spell or remember web addresses)
>
> Specify the data table(s), or parts of tables that you want to download
from
> the site, etc. It's a pretty simple operation! Click the refresh button
> anytime that you want new data. The web query can be easily programmed
using
> VBA for refresh times and site sequences for simple edits using "Edit
Query"
> on the "External Data" toolbar.
>
> Several very good books re Excel 2000 VBA programming have come out
> recently. Not a lot of changes to VBA between 97 and 2000. Wallenbach's
VBA
> 1,000 pager is more integrated with Excel user tips and tricks, the 21
day
> VBA course 1,000 pager is a "hand-holder" for non-programmers like
myself.
>
> One unique book is the Excel VBA programmers reference manual at
> http://www.wrox.com/Store/Details.asp?Code=2548. Over 300 pages of
> Appendices listing all of the VBA objects and methods, etc. It also
includes
> another Appendix on programming the objects and methods of the VBE which
I
> didn't know that you could do.
>
> What an amazing program Excel is. Imagine manually adding combinations of
> indicators to your charts in Metastock and have the System Tester
> automatically write code for you. Maybe some day.
>
> Best regards
>
> Walter
>
>
>
>
>
>




  • References: