|
PureBytes Links
Trading Reference Links
|
Walter,
The only bad thing that could happen when you try something is the
destruction of the western world! <bg>
Now, you've got a lot of lines on this sheet after one day's
downloads. I presume the next thing you want to do is to delete
everything but "corn"? Is that the case?
If so then help me once again identify those lines that are "corny".
Once you do this then I'll write a VB macro the will have a button to
click that will fire up the web query and will delete all of the
non-corny lines. After that we'll discuss what you want to do with the
corn, i.e. add it to a corn history sheet, build and export a csv
file, etc..
Dale
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Walter Lake
> Sent: Monday, March 15, 1999 9:52 AM
> To: Metastock bulletin board
> Subject: easy as pie
>
>
> Oh ... is this easy or what!
>
> Steps:
>
> Save ".igy" file from Dale's email into C:\Program Files\Microsoft
> Office\Queries
>
> Open a workbook in Excel 97
>
> Click any cell, i.e., B3 {this is where I want the data placed for
> starters}
>
> Click ... Data --> Get External Data --> Run Web Query
>
> The "Run Query" dialogue box appears
>
> Click on "test.igy" ... {I called it "test#2.igy" because
> as Dale explained
> it needed a date}
>
> Click "Get Data" Button
>
> Dialog box "Returning External Data to Microsoft Excel"
> appears asking you
> where you want the data put. Since I already clicked B3 ...
> $B$3 appears in
> box
>
> Click "OK" button
>
> "Enter Parameter Value" dialogue Box appears {I don't know
> what this means}
>
> I entered date "990312"
>
> The Excel screen immediately appeared with the little
> notice "Getting Data"
>
> In seconds the data appeared ... lots of it
>
> Little tool bar "External Data" is floating in the middle
> of the screen.
>
>
> Wow ... kiss my download fees goodbye.
>
> Try it ... you'll love it.
>
> Best regards
>
> Walter
>
>
>
>
>
>
|