Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
microsoft.public.excel.programming
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Message from discussion Problem with user created Functions
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Norman Harker  
View profile  
 More options Aug 31 2001, 10:56 am
Newsgroups: microsoft.public.excel.programming
From: "Norman Harker" <nhar...@ozemail.com.au>
Date: Sat, 1 Sep 2001 00:54:56 +1000
Local: Fri, Aug 31 2001 10:54 am
Subject: Re: Problem with user created Functions
Print | View thread | Show original | Report this message | Find messages by this author
Hi John & Niek!

If you put your Addins in:

C:\Program Files\Microsoft Office\Office\Library

You don't need to browse to find the Addin.

It also makes life easier on removal as all Addins you install are in one
place. I believe that there are removal problems if the Addin is not located
in the Library file where pre-2000 versions are concerned.

hth

"Niek Otten" <nicol...@xs4all.nl> wrote in message

news:exv9vpiMBHA.1368@tkmsftngp02...
> You may have forgotten to mention it, but one step is missing in your
> recipe:

> Tools>Add-ins, browse to the right directory and doubleclick MyFunctions

> Regards,

> Niek Otten

> "John Barrington" <jbarrington_REMOVE_@_REMOVE_home.com> wrote in message
> news:nKMj7.331902$qc.39194059@news1.rdc1.va.home.com...
> | How can I create a function and locate it in one central place for every
> | open workbook to access?
> |
> | The function appears to work fine if there's a copy of it in EVERY
> | workbook's module, but will not work if there's only ONE accessible copy
> in
> | all the open workbooks that I'm using, such as the workbook
PERSONAL.XLS.
> |
> | I read an earlier replied posting that stated a function should be
placed
> in
> | and saved as a XLA file, and then installed as an Add-in before being
able
> | to access the function within all open workbooks. I tried this and it
> didn't
> | appear to work unless I didn't do something correctly.
> |
> | I created a XLA file called MyFunctions.XLA , saved it, and then started
> | transferring a few of my newly created functions into designated module.
I
> | then resaved the XLA file and tried to use my functions, but the other
> open
> | workbooks couldn't seem to see them for some reason. All I saw within
the
> | cells was an error #NAME?
> |
> |
> |


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google