[jawsscripts] Re: automating commands to extract info from web site?
- From: "Reed Poynter" <Reed.Poynter@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Tue, 1 Mar 2011 22:00:50 -0800
It sounds to me that you could really use the Web Query facility in Excel
2003. It is found under data, import data, web query.
If you Google "excel 2003 web query", you will find several sites that show
you how to use it.
Quite often, I will use the record a macro facility to capture the steps
taken to create an import. Then I will edit the recorded macro to customize
it and/or to edit the data imported.
I have found Excel's record a macro feature to be invaluable in learning to
use macros. If I want to find out how to do something in a macro, I will
start recording, walk through the steps required to do that something on the
keyboard, stop recording and go look at the macro created. This process has
saved me from many hours of frustration.
Good luck.
Reed
-----Original Message-----
From: jawsscripts-bounce@xxxxxxxxxxxxx
[mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie Medlar
Sent: March-01-11 6:43 PM
To: jawsscripts@xxxxxxxxxxxxx
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
Hi Don,
Thanks for all your help so far. No money yet but maybe after I get my
procedure automated. LOL
Anyway here is link for a tutorial. I did lesson 1 and hope I can follow
directions without the pictures. I really should learn some Visual Basic.
http://www.excel-vba.com/excel-macros-beginners.htm
----- Original Message -----
From: "Don Marang" <donald.marang@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Tuesday, March 01, 2011 8:06 PM
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> Try hitting F1 in Excel for help and typing something similar to "web
> data"
> in the search box. I have Office 2007, so I do not know if all of the
> great
> features are available in 2003. What you want is some type of web query.
> I
> attempted to follow the directions in the help, but not all of the steps
> in
> the help were easily accessible. You should be able to select a table on
> the webpage and Excel helps you create a new web query. In Excel 2007,
> You
> can also create a web query through the ribbon: Data > Web Source >
> (probably available in the 2003 menus).
>
> It may be easier to copy one of the examples of web queries that come with
> Excel. Some of them are also to look up stock quotes. Then you can edit
> the query and change it's properties. In the properties, there are
> interesting features such as determining when the data is refreshed or
> continually updated. I think Alt + F5 will manually ask if you want to
> update the external sources.
>
> If I give you any more help, you will need to provide me a percentage of
> everything you make on the market (not the losses)! <grin>
>
> Don Marang
> Vinux Software Development Coordinator (vinux.org.uk)
>
> There is just so much stuff in the world that, to me, is devoid of any
> real
> substance, value, and content that I just try to make sure that I am
> working
> on things that matter.
> Dean Kamen
>
>
> --------------------------------------------------
> From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
> Sent: Tuesday, March 01, 2011 7:35 PM
> To: <jawsscripts@xxxxxxxxxxxxx>
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>> Hi all,
>> Well I have Excel 2003 and I googled macro programming and a tutorial is
>> available for excel so I think I'll try it in the morning. Thanks for
>> all
>> your help.
>> Someone recommended macro express but it costs $$ and I rather try the
>> free
>> stuff first.
>>
>> ----- Original Message -----
>> From: "Don Marang" <donald.marang@xxxxxxxxx>
>> To: <jawsscripts@xxxxxxxxxxxxx>
>> Sent: Tuesday, March 01, 2011 4:48 PM
>> Subject: [jawsscripts] Re: automating commands to extract info from web
>> site?
>>
>>
>>> JAWS scripts gets a little more complicated in this scenario since it
>>> is
>>> not for a single application. Therefore, it probably would needed to be
>>> added to your default scripts. This can easily screw up JAWS if you
>>> even
>>> get a simple compile error due to a mistyped character. I would not
>>> recommend beginners write default scripts.
>>>
>>> Freedom Scientific now has some documentation on their website to write
>>> rule
>>> and query files for ResearchIt. It uses some open language built around
>>> SQL
>>> type code to generate text in the virtual buffer. You would need to
>>> copy
>>> all then paste the results even after writing the rules file.
>>>
>>> I think using Microsoft's tools built into Excel would be your best bet.
>>> This may include specifying an external data source, internal functions,
>>> macros and edit it's own Visual Basic that the macros can generate.
>>>
>>> One thing to check that might make any automation easier is to check if
>>> the
>>> stock symbol, like ARMH, shows up somewhere in the address bar after you
>>> type in the signal and hit enter on the Go button. If so, you can
>>> bypass
>>> the edit box and go directly to the results page. Copy the entire URL
>>> in
>>> the address bar. I am not familiar with Excel's syntax for grabbing
>>> data
>>> from websites, but this URL will be critical. You can most likely
>>> replace
>>> the symbol text typed into the edit box with a cell coordinate to work
>>> with
>>> any symbol. I would attempt to place each piece of information you
>>> currently append to clipboard to separate cells or areas of cells.
>>>
>>> Don Marang
>>> Vinux Software Development Coordinator (vinux.org.uk)
>>>
>>> There is just so much stuff in the world that, to me, is devoid of any
>>> real
>>> substance, value, and content that I just try to make sure that I am
>>> working
>>> on things that matter.
>>> Dean Kamen
>>>
>>>
>>> --------------------------------------------------
>>> From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
>>> Sent: Tuesday, March 01, 2011 1:32 PM
>>> To: <jawsscripts@xxxxxxxxxxxxx>
>>> Subject: [jawsscripts] Re: automating commands to extract info from web
>>> site?
>>>
>>>> Hi James and all:
>>>> I typed my keystrokes below after my note that I need to automate. My
>>>> problem is that I know how to find the info in terms of Jaws but not in
>>>> terms in a web language. So if you or anyone knows what the web
>>>> language
>>>> is for heading, table, copy and append to clipboard,
>>>> F8 key please let me know so I know what to look for to automate using
>>>> this
>>>> utility. I just began reading the documentation. I was a mainframe
>>>> computer programmer but don't know any PC languages. Any help
>>>> appreciated.
>>>> Thanks,
>>>> Ann
>>>> Keystrokes:
>>>> Open site:
>>>> http://www.barChart.com
>>>> Note: edit box is part of a table
>>>> type e for edit and enter ticker symbol
>>>> I type ARMH for Arm Holdings
>>>> tab to go and enter
>>>> type h for heading for company name
>>>> control+c to copy heading containing company name
>>>> type t for table containing Stock price info
>>>> up arrow once
>>>> press f8 to select all table info
>>>> windows+c to append table info
>>>> type t for table
>>>> up arrow
>>>> F8 to highlight table info containing 2nd Resistance Point
>>>> windows+c to append table info
>>>> Find heading containing Today's Opinion which is a link and enter
>>>> Literals from web site:
>>>> Detailed Opinion Show Signal Strength and Direction
>>>> table has 4 columns and 34 rows
>>>> F8 to highlight table containing todays opinion
>>>> windows+c to append
>>>> alt+F4 to exit site
>>>> alt+control+N for NotePad
>>>> Control+v to paste
>>>> Control+s to save
>>>> Prompt user for file name
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> http://barchart.com/opinions/stocks/ARMH
>>>> ----- Original Message -----
>>>> From: "Homme, James" <james.homme@xxxxxxxxxxxx>
>>>> To: <jawsscripts@xxxxxxxxxxxxx>
>>>> Sent: Tuesday, March 01, 2011 12:38 PM
>>>> Subject: [jawsscripts] Re: automating commands to extract info from web
>>>> site?
>>>>
>>>>
>>>>> Hi Ann,
>>>>> To be honest with you, it's going to be difficult unless you
>>>>> absolutely
>>>>> know you will be putting in the same exact command sequence. If you
>>>>> want
>>>>> to do it through scripting, you could do it, but if I were you, I
>>>>> would
>>>>> look into this free tool. http://seleniumhq.org/
>>>>>
>>>>> Jim
>>>>> -----Original Message-----
>>>>> From: jawsscripts-bounce@xxxxxxxxxxxxx
>>>>> [mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie
>>>>> Medlar
>>>>> Sent: Tuesday, March 01, 2011 12:18 PM
>>>>> To: jawsscripts@xxxxxxxxxxxxx
>>>>> Subject: [jawsscripts] Re: automating commands to extract info from
>>>>> web
>>>>> site?
>>>>>
>>>>> Hi all,
>>>>> If I write out a series of windows and jaws commands sequentially to
>>>>> go
>>>>> to
>>>>> web, prompt to enter info in edit box, use Jaws to navigate info,
>>>>> copy
>>>>> and
>>>>> append info then alt+control+N for NotePad and then paste info and
>>>>> save
>>>>> text
>>>>> file.
>>>>> could some of you give me guidance to script?
>>>>> I would love to automate this processs because it would save me so
>>>>> much
>>>>> time.
>>>>> thanks for any feedback.
>>>>> I use Jaws 11 or 12 and xP Media.
>>>>> Thank you so much.
>>>>> Ann
>>>>>
>>>>> __________�
>>>>>
>>>>> View the list's information and change your settings at
>>>>> //www.freelists.org/list/jawsscripts
>>>>>
>>>>>
>>>>> This e-mail and any attachments to it are confidential and are
>>>>> intended
>>>>> solely for use of the individual or entity to whom they are addressed.
>>>>> If
>>>>> you have received this e-mail in error, please notify the sender
>>>>> immediately and then delete it. If you are not the intended
>>>>> recipient,
>>>>> you must not keep, use, disclose, copy or distribute this e-mail
>>>>> without
>>>>> the author's prior permission. The views expressed in this e-mail
>>>>> message
>>>>> do not necessarily represent the views of Highmark Inc., its
>>>>> subsidiaries,
>>>>> or affiliates.
>>>>> __________�
>>>>>
>>>>> View the list's information and change your settings at
>>>>> //www.freelists.org/list/jawsscripts
>>>>>
>>>>
>>>> __________�
>>>>
>>>> View the list's information and change your settings at
>>>> //www.freelists.org/list/jawsscripts
>>>>
>>>>
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> //www.freelists.org/list/jawsscripts
>>>
>>
>> __________�
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>>
> __________�
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
>
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
