Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Unfortunately, 12 minutes between your previous post and this one is not a
new record for impatience. The people who provide information in these newsgroups are not paid and do have lives, so it is quite common for there to be a lag between when you post a question and when a particular person may read and respond to that question. Another aspect of us not being paid, is that in effect you are asking us to do you a favor. Is this how you ask for favors in the real world? I'm sorry that you are having so much trouble figuring out how to use the Smith library; most people don't. Also, forgive me if I have over-estimated your level of understanding, but if you dont ask specific questions, we have to make assumptions. The simplest way to use the Smith library is to add worksheets to Examples.xls, which you downloaded from Ian Smith's web page. The code is already in that workbook, so you can simply use it on worksheets that you add to that workbook. If adding your workbooks into Examples.xls is not appropriate, you can use Alt+F11 to start the VBA Editor. In the Project window, under Examples.xls you will find a folder marked €śModules€ť. In that folder is a single module page that contains all the VBA code for Smiths functions. For the workbook that you want to add the code to, you can Insert|Module from the VBA Editor menu, then copy the code from the Examples.xls module into the one you added to the new workbook. The resulting calculations would be slightly less accurate than in Examples.xls, due to the MS decision to display no more than 15 figures on floating point numbers. You can achieve the same precision as in Examples.xls by pasting the code into a text editor. In that text editor, wherever there is a code comment (preceded by a single quote) that contains a numeric value to more figures than is shown in the actual code, then copy/paste the commented value over the code value. When finished, copy all the code from the text editor into the module that you added to the new workbook. This is a lot of work and presumes a certain level of understanding; hence my suggestion that the easiest approach is to add worksheets to Examples.xls. Jerry "Dora Smith" wrote: Umm, Jerry, I expect people to tell me how to use things I obviously don't know how to use, if they are going to tell me to use them. What is supposed to be the earthly point of telling someone to use something and not tell her how to use it? Are you trying to help me, or merely show off your knowledge and play up how much I don't know? No - don't answer that. There are some people on this newsgroup who are helpful, and others whose experience or whatever is truly unique. Maybe it's called academic statistics; I don't know - people in that department sure were a prize when I went to school! And yours isn't even the best of the exasperating answers! Sorry. I know you wanted the prize for creative rudeness. I don't still go to that school, and I'm not in academia, and you aren't going to intelligibly answer my questions no matter what I do or don't do, so I've no particular reason to be patient with your rudeness. But you were too arrogant to think of all that. -- Yours, Dora Smith Austin, TX "Jerry W. Lewis" wrote in message ... Perhaps your experience has been different, but I have generally found it counterproductive to blame those I was seeking help from for my lack of understanding, instead of simply asking for clarification. Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Confidence Intervals | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Generate 1-to-1 outputs for a list of inputs into a excel formula | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |