From:

 Doug Geoffray

Subject:

 Re: MS/Excel 2007 and Headings that aren't really headings

Date:

 Thu, Jun 16, 2011 2:04:12 pm

Amanda,

In the manual go to the "Window-Eyes Features" node. Under that you'll
find Working with "Microsoft Excel." Under that you'll see "Headers and
Totals". I believe this describes the steps you are needing.

For the record, I also didn't know where in the manual this was
described so while in the manual I just pressed alt-s for the search and
typed "excel" and hit enter. I than tabbed until I got to the listview
of results and arrowed down until I got to "Headers and Totals" (for me
this took 2 down arrows). I hit enter on this and pressed f6 to get
the to content and there I was.

Doug

On 6/16/2011 1:53 PM, Amanda Lee wrote:

Ok, tried it but it errors out expecting a name. I didn't see
anything in the manual under Office or an example but I think I got it

working.
Thanks.

----- Original Message -----

*From:* Doug Geoffray
*To:* gw-scripting@gwmicro.com

*Sent:* Thursday, June 16, 2011 1:34 PM
*Subject:* Re: MS/Excel 2007 and Headings that aren't really headings

Amanda,

Just to be clear what Ralf suggested doesn't have to be done for

each of the possible 100 columns. You could have as many columns
as Excel supports, as long as they are on the same row this is all

done once and only once per worksheet.

Doug

On 6/16/2011 1:25 PM, Amanda Lee wrote:

As i said for everytime you get a completely new version of
certin spreadsheets, everything will have to be duplicated once

again so if this spreadsheet is changed out hourly and one has to
define each of 100 or more headings each time, this is very

unproductive in terms of time spent performing one's work.
As I say the competition enables a workaround and in this

instance they're getting the edge.

----- Original Message -----
*From:* Ralf Kefferpuetz

*To:* gw-scripting@gwmicro.com

*Sent:* Thursday, June 16, 2011 1:09 PM
*Subject:* RE: MS/Excel 2007 and Headings that aren't really

headings

Amanda,

why not just use the column and row header hotkey
alt-shift-h? It is a5 second task to define the cells in the

first row as a header, as well as the cells in the first
column as row headers.

Maybe I did not get your point?

Cheers,

Ralf

Ralf Kefferpuetz

Germany

*From:*Amanda Lee [mailto:amanda.e.lee@verizon.net]

*Sent:* Thursday, June 16, 2011 5:32 PM
*To:* gw-scripting@gwmicro.com

*Subject:* MS/Excel 2007 and Headings that aren't really headings

Oftentimes I find Excel spreadsheet applications with
improperly coded headingss and some which are exported from

other applications which result similarly.

Haven't been able to attend WE App development training or
I'd make an attempt to develop something which would treat

each column of the first ro of a spreadsheet row and speak it
as one navigates through each column such as the WE Office

hotkeys should do if there are proper Headings coded.

It would also treat the first column of every row the same
and preferably have a toggle to activate this feature if

desired as not all rows have headings in every spreadsheet.

The competition allows one to change their Verbosity settings
which of course isn't pure but its a decent workaround.

Still as always would rather rely upon Window-Eyes for it's
responsiveness, stability and all of it's superior qualities.

Yes one can manually correct spreadsheets but this becomes

very time-consuming when there's 100 or more columns and the
spreadsheet is replaced often!

So if anyone has a little spare time, I know that there would

be many who would be grateful for this one!