Roger,
The old are the best! I'm in my mid-70's myself and I am delighted to find
that I am called upon to develop macros to resolve financial issues, mostly
managing Excel worksheets.
I am fully blind and cannot make any use of visual formats but rely entirely
on text. For this reason, I have not bothered with charts and certainly have
avoided handling the appearance of the screen. I am happy to specify the
format of characters as this is such a matter of personal taste that the
user needs to approve any formats that I might offer even if I could see
them.
To get started, give me a simple situation with a spreadsheet that you would
enjoy controlling with a macro and we can build that into a simple module.
By the way, a program in VBA is enclosed between two key phrases:
"Sub WhatYouWant()
Code here ..
End Sub
This is the entire program and is called a module. The keyword "sub" is
followed by the name that you want to call the subroutine and followed by
open parentheses. The name can be any text but the first character cannot be
a number. The two words "End Sub" are essential to indicate the end of the
subroutine.
We will need to explore the Visual basic Editor and the Developer tag on the
menu to get things going.
The best way to get started is to try a program. After that, the terminology
will get going on a "need to know" basis.
Does that sound OK?
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx
From: program-l-bounce@xxxxxxxxxxxxx <program-l-bounce@xxxxxxxxxxxxx> On
Behalf Of Roger Woolgrove
Sent: Wednesday, June 19, 2019 3:07 PM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Re: Excel Expert Wanted: Help Setting Up and Using
Relational Data
Hi Cearbhall
I haven't started with macros at any point and know nothing.
I write software in java script, java, python and html so far. I'm fairly
quick to learn language once I understand the principles.
Thanks for getting back to me and like you I'm a bit tired of click here and
enter this over here on you tube videos.
No sight using NVDA on Win 10.
I've used blue-j because I'm old, notepad++ and netbeans/sodbeans and
haven't dipped my toes into anything else yet. I was thinking to start with
eclipse.
So those are the languages and IDEs.
If you are able to point me at where to start and the tools and any tricks
to make life a little easier that would be great.
thanks again
roger
On 19/06/2019 13:49, Cearbhall O'Meadhra wrote:
Roger,
Good to hear from you!
There are many good tutorials on the web. I just Google to find solutions
that I need in which experts supply answers to questions raised by others.
None of these have anything to do with accessibility, of course, that is
something we have to field ourselves.
The biggest nuisance that I have found is YouTube. Most people seem to
prefer to explain code and methods with a YouTube video in which they
frequently use such words as "this" "here" and "as you can see" - all of
which excludes anyone who cannot see what they are talking about. Another
snag which is really maddening is in really useful text-based instructions,
not on YouTube, on appropriate code in which the author explains well what
to do but then presents a sample code as a graphical image! This prevents
us from getting to grips with the exact procedure to follow.
Before I make any further recommendations, could you tell me what you have
tried until now? Are you a complete novice? If not, where would you like me
to pick up.
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx
<mailto:cearbhall.omeadhra@xxxxxxx>
From: program-l-bounce@xxxxxxxxxxxxx <mailto:program-l-bounce@xxxxxxxxxxxxx>
<mailto:program-l-bounce@xxxxxxxxxxxxx> <program-l-bounce@xxxxxxxxxxxxx> On
Behalf Of Roger Woolgrove
Sent: Wednesday, June 19, 2019 1:50 AM
To: program-l@xxxxxxxxxxxxx <mailto:program-l@xxxxxxxxxxxxx>
Subject: [program-l] Re: Excel Expert Wanted: Help Setting Up and Using
Relational Data
Cearbhall
I've always wanted to know how to make accessible macros for Excel. Can you
point me at any resources. I'm total using NVDA on Win10.
many thanks
roger
On 18/06/2019 23:17, Cearbhall O'Meadhra wrote:
Hi, Jim,
I virtually live with Excel and would be happy to see if I can help with
your thoughts. I do formulas, macros and simple routine tasks as well!
I can be reached on Facetime, WhatsApp, team talk - you name it!
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx
<mailto:cearbhall.omeadhra@xxxxxxx>
From: program-l-bounce@xxxxxxxxxxxxx <mailto:program-l-bounce@xxxxxxxxxxxxx>
<mailto:program-l-bounce@xxxxxxxxxxxxx> <program-l-bounce@xxxxxxxxxxxxx> On
Behalf Of Jim Homme
Sent: Tuesday, June 18, 2019 8:40 PM
To: program-l@xxxxxxxxxxxxx <mailto:program-l@xxxxxxxxxxxxx>
Subject: [program-l] Excel Expert Wanted: Help Setting Up and Using
Relational Data
Hi,
If anyone is willing to talk to me privately about this, I don't want to
clog up the list with this, because I think it requires a conversation. I'm
trying to wrap my head around some Excel functions and what I would like to
set up. I want to get help thinking through how to set up what I want with
data and formulas.
Thanks.
Jim
==========
Jim Homme
Digital Accessibility
Bender Consulting Services
412-787-8567
<https://www.benderconsult.com/our%20services/hightest-accessible-technology
-solutions>
https://www.benderconsult.com/our%20services/hightest-accessible-technology-
solutions
