Created a function, for the personal.xlsb file

[hitbid]

I just started creating some functions, not sure why I ignored this functionality but they are really handy.

I had a very simple one I figured I would just port over to the personal workbook and be able to use, but it seems functions are not as functional as macros, in that I can't access the function outside of the workbook it is located in.

Is there a way around this? How do you access a function in your personal workbook?

 

[My Aswer Is This]

I have Functions in my Personal Workbook that i can use on any Workbook.
Do you know how to put macros in your personal workbook?

I just create the function or macro and then in the Vba Project window drag it into the Personal Workbook
And then there it stays.

Show us your function.

 

[hitbid]

Do you know how to put macros in your personal workbook?

Yes, I have many modules.

I created a new module called functions, in preparation for creating these new functions.

My first one is really simple.

Function sqlp(cell)


sqlp = """" & cell & """"


End Function

I added this to the module, but cannot use it in any other workbook.

 

[My Aswer Is This]

So the function works in your workbook?

Did you drag the module into your Personal Workbook??

 

[hitbid]

Yes, I put the function into the Personal.xlsb workbook, into "Thisworkbook" and it's own module, so it is in there in two separate places. Then I open a new workbook, no dice.

 

[My Aswer Is This]

You did not answer this question.

So the function works in your workbook?
Has the function ever worked for you??
​

 

[hitbid]

Going to read through this.
From what I've found so far after originally posting this, using UDFs across multiple workbooks is not as easy as macros, much to my disappointment.

https://social.msdn.microsoft.com/F...workbooks-reference-being-lost?forum=exceldev

 

[hitbid]

You did not answer this question.

So the function works in your workbook?
Has the function ever worked for you??
​

The function only works in the workbook it is stored in.
Yes the function works.
But if I open jazzy.xls and try to use it, it doesn't work there, since jazzy.xls doesn't have the function in the module project area.

 

[My Aswer Is This]

Well on my system I always use macro enabled workbooks
I do not believe you can use a function is a non macro enabled workbook.

But I'm no expert.

Try seeing what happens if you try and use it in a different Macro enabled workbook.

I do not know what type file xls is

I'm using xlsm

 

[hitbid]

Looks like it is working now.

I saved a new file with the custom UDF as a .XLAM file, (Add-in format). I closed excel, re-opened, and went to the add-ins section. My new file was now available as a selection in the add-ins. I checkmarked the add-in, closed excel, and opened a brand new worksheet. The UDF now worked in the file.

I realize that if I send the file to someone else and they do not have the add-in on their computer they will get an error instead of a proper formula calculation, but I can live with that.

This did not touch the personal file at all, so I am not sure how yours works, but I am happy with my process now.

Cheers