View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
houghi houghi is offline
external usenet poster
 
Posts: 56
Default Good books and sites for excel VB?

Bob Phillips wrote:
What do you know already?

Do you know Excel well or not so well?


I know it well. I am able to make macro's and edit them

Are you familiar with programming languages generally or not at all?


I can script in general. I write scripts in bash. So loops and so on are
not an issue for me to understand. I also understand the sub and write
many smaller macro's and scriopts that I then link together.

Are you familiar with the syntax of VB or not at all?


Somewhat. I can understand when I make a macro and am able to read and
understand about 50-75% of other peoples code. However I am not good
enough to come up with my own code.
I know what I want. I know the steps on how to get there. It is just
that I am unable to do that last step of actualy writing the code for
the missing parts.

I have several sources (about 7 or 8) that I need to put into several
other weekly and monthly reports and obviously need to automate that.

Manualy it takes me about 4-5 hours per week and it should be done by
the press of a button. Also I do not want to ask you people here to
solve all my problems, even though all the questions I have had got a
great answer.

Are you familiar with the Excel object model, or not at all.


It is the first time I hear the name, so I would say not at all. :-)


houghi
--
At the source of every error which is blamed on the computer you will
find at least two human errors, including the error of blaming it on
the computer.