simple excel book for VB and object

keithkemble · Feb 16th, 2002, 04:26 PM

The Excell help is limited. I have learnt a fantastic amount of hidden functions from the bulletin board and wish to enlarge my KB further.

I am looking for an VB book and object listing, functions etc that demonstrate the working of the said definition.
Maybe accompanied by a cd etc
Any pointer would be grateful.
Thanks

Barrie Davidson · Feb 16th, 2002, 05:58 PM

Keith, a few years ago I bought a book titled "Visual Basic for Applications Unleashed" and found it very helpful. It's published by SAMS Publishing.

Feb 17th, 2002, 03:30 AM

Hi Kieth -

Hi mate your London at a guess right? Im London South Stretham / Brixton (i know cheerful areas) But look i work in Software and Finance i have access to a lot if i can be bothered that is. I could keep you in mind and get some stuff.

I have loads of manuals of many Microsoft software, i did get MS Excl VBA PRESS version $25 (pounds not $) and most MS books are good if limited.

Go to Amazon or Jungle on the web and have a look - I only buy MS Books but they are sometimes limited.

BEST input i can give is this, ill get shot for these comments but ill tell you straight.

Some of the guys on this board are a lot better and knowledgeable that they let on, and many are GURUS i really mean this, look at there web sites and rip their work apart, save EVERY page and print it and learn it inside out abd upside down, theres about 10 guru web site i refere to most on MrExcel as well, so books ???? try my suggestion, you but the work in and get th results.

Also remember you can post questions if your unsure, ive made good friends here ... they really will help you and the skys the limit.

take care mate.. drop your email ill bounce some VBA stuff i have for you...

Rdgs
==========
Jack

keithkemble · Feb 17th, 2002, 04:28 AM

Jack,

Appreciated.

Your right about the gurus. They have been tremendous towards me. Its greatly appreciated. I have no intention of leaving this board its so flexible.

I have ordered a book Office 97 Annoyances from the USA. I look forward to seeing it.
If Mr excel is listening his links go to Amazon USA. If we buy from the Amazon Uk does he still get his earner.

PS
Would you be jack in the Uk from the previous board.
KK

PS to Barrie, I will search for your recommendation when I return from playing golf.

Jack in the UK · Feb 17th, 2002, 08:32 AM

Hi --

Yep its me ... typos joining the place.. and all the agros finding my way about - could do with a manual!

At least no people cant use my name and slag me off quite so easy... as they wont have my password..i was getting sick of getting posts remoeved.

So thats good.. like i say post me if i can help SURE! I HAVE A LOOK ABOUT FOR YOU...

RWinfield · Feb 17th, 2002, 07:54 PM

Kieth, I have a file that I downloaded from somewhere (just don't remember where to give the author credit) which is an .XLS file that covers every function in excel and gives a description and examples of the usage. It is a workbook with 166 worksheets in it. I would be happy to forward it to you if you like. The file is xlfdic01.zip and is 276K bytes zipped. If you want me to email this to you please email me at the address shown here, as I do not send non requested attachments to emails.

Rick

JohnJay · Mar 8th, 2002, 09:05 AM

Rick the address for that file is:

http://homepage.ntlworld.com/noneley/

Feb 16th, 2002, 05:58 PM	#2
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Keith, a few years ago I bought a book titled "Visual Basic for Applications Unleashed" and found it very helpful. It's published by SAMS Publishing. __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 16th, 2002, 04:26 PM	#1
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	The Excell help is limited. I have learnt a fantastic amount of hidden functions from the bulletin board and wish to enlarge my KB further. I am looking for an VB book and object listing, functions etc that demonstrate the working of the said definition. Maybe accompanied by a cd etc Any pointer would be grateful. Thanks

Feb 17th, 2002, 03:30 AM	#3
Guest Posts: n/a	Hi Kieth - Hi mate your London at a guess right? Im London South Stretham / Brixton (i know cheerful areas) But look i work in Software and Finance i have access to a lot if i can be bothered that is. I could keep you in mind and get some stuff. I have loads of manuals of many Microsoft software, i did get MS Excl VBA PRESS version $25 (pounds not $) and most MS books are good if limited. Go to Amazon or Jungle on the web and have a look - I only buy MS Books but they are sometimes limited. BEST input i can give is this, ill get shot for these comments but ill tell you straight. Some of the guys on this board are a lot better and knowledgeable that they let on, and many are GURUS i really mean this, look at there web sites and rip their work apart, save EVERY page and print it and learn it inside out abd upside down, theres about 10 guru web site i refere to most on MrExcel as well, so books ???? try my suggestion, you but the work in and get th results. Also remember you can post questions if your unsure, ive made good friends here ... they really will help you and the skys the limit. take care mate.. drop your email ill bounce some VBA stuff i have for you... Rdgs ========== Jack

Feb 17th, 2002, 04:28 AM	#4
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	Jack, Appreciated. Your right about the gurus. They have been tremendous towards me. Its greatly appreciated. I have no intention of leaving this board its so flexible. I have ordered a book Office 97 Annoyances from the USA. I look forward to seeing it. If Mr excel is listening his links go to Amazon USA. If we buy from the Amazon Uk does he still get his earner. PS Would you be jack in the Uk from the previous board. KK PS to Barrie, I will search for your recommendation when I return from playing golf.

Feb 17th, 2002, 08:32 AM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi -- Yep its me ... typos joining the place.. and all the agros finding my way about - could do with a manual! At least no people cant use my name and slag me off quite so easy... as they wont have my password..i was getting sick of getting posts remoeved. So thats good.. like i say post me if i can help SURE! I HAVE A LOOK ABOUT FOR YOU...

Feb 17th, 2002, 07:54 PM	#6
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	Kieth, I have a file that I downloaded from somewhere (just don't remember where to give the author credit) which is an .XLS file that covers every function in excel and gives a description and examples of the usage. It is a workbook with 166 worksheets in it. I would be happy to forward it to you if you like. The file is xlfdic01.zip and is 276K bytes zipped. If you want me to email this to you please email me at the address shown here, as I do not send non requested attachments to emails. Rick

Mar 8th, 2002, 09:05 AM	#7
JohnJay New Member Join Date: Mar 2002 Posts: 37	Rick the address for that file is: http://homepage.ntlworld.com/noneley/