Add-in

Feb 28th, 2002, 07:53 AM

Hi, I'm Rios, I'm new here.

I created a function VBA and I saved the file in the format XLA. When I try to use the function, I see that the function appears as " file.xla!modulef.calcfun ". How do I do so that the function appears how all the existent ones? (ex. calcfun)

Mudface · Feb 28th, 2002, 08:47 AM

Hi, Rios- it sounds like you haven't actually installed your function as an add-in yet. To do this, click on Tools-Add-Ins and Browse to the location of your add-in and install it. Your function should now be available to all Excel workbooks on your computer under the right name.

Rios · Feb 28th, 2002, 08:58 AM

This was made. Then, when access the function saw " fx " (past-function) the name of the function doesn't come clean, but preceded of the file and module.

Mudface · Feb 28th, 2002, 09:08 AM

If you have actually installed it as an add-in and aren't just running it side by side with a worksheet, you shouldn't get this, so I'm afraid I don't have an explanation why.

Click on Tools- Add-Ins and look down the list to check your add-in hasn't been unchecked by mistake, is the only thing I can think of.

Rios · Feb 28th, 2002, 09:18 AM

I really tried.... I will restart the process in another installation Excel and to try.

Really thank you.

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

Feb 28th, 2002, 07:53 AM	#1
Guest Posts: n/a	Hi, I'm Rios, I'm new here. I created a function VBA and I saved the file in the format XLA. When I try to use the function, I see that the function appears as " file.xla!modulef.calcfun ". How do I do so that the function appears how all the existent ones? (ex. calcfun)

Feb 28th, 2002, 08:47 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Hi, Rios- it sounds like you haven't actually installed your function as an add-in yet. To do this, click on Tools-Add-Ins and Browse to the location of your add-in and install it. Your function should now be available to all Excel workbooks on your computer under the right name.

Feb 28th, 2002, 08:58 AM	#3
Rios New Member Join Date: Feb 2002 Location: Brazil Posts: 4	This was made. Then, when access the function saw " fx " (past-function) the name of the function doesn't come clean, but preceded of the file and module.

Feb 28th, 2002, 09:08 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If you have actually installed it as an add-in and aren't just running it side by side with a worksheet, you shouldn't get this, so I'm afraid I don't have an explanation why. Click on Tools- Add-Ins and look down the list to check your add-in hasn't been unchecked by mistake, is the only thing I can think of.

Feb 28th, 2002, 09:18 AM	#5
Rios New Member Join Date: Feb 2002 Location: Brazil Posts: 4	I really tried.... I will restart the process in another installation Excel and to try. Really thank you.