Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use a UDF (module) across many users (embedd in worsheet)
Hi, I am using a UDF to strip non numeric text out of a cell.
That is: Function StripTxt(a As String) As String ' Strips all non-numeric characters from a string ' Returns a string, not a number! Dim i As Long Dim b As String For i = 1 To Len(a) b = Mid$(a, i, 1) If Asc(b) 47 And Asc(b) < 58 Then StripTxt = StripTxt + b Next i End Function My questions is, when someone other than me opens this workbook, it references their local C Drive profile for the location of the xla file. Is there a way such that I can embedd this UDF in the workbook itself, such that it doesn't have to reference an external file? That is, I want the code related to stripping the text, to remain in the workbook, so that another user other than the one that created the function can use it. Any assistance would be appreciated. John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use a UDF (module) across many users (embedd in worsheet)
It's all good. For some reason the module was saved to a temporary file of
some sort. re did the process and now all is good. :) -- Your assistance is appreciated. Griffo "GRIFFO" wrote: Hi, I am using a UDF to strip non numeric text out of a cell. That is: Function StripTxt(a As String) As String ' Strips all non-numeric characters from a string ' Returns a string, not a number! Dim i As Long Dim b As String For i = 1 To Len(a) b = Mid$(a, i, 1) If Asc(b) 47 And Asc(b) < 58 Then StripTxt = StripTxt + b Next i End Function My questions is, when someone other than me opens this workbook, it references their local C Drive profile for the location of the xla file. Is there a way such that I can embedd this UDF in the workbook itself, such that it doesn't have to reference an external file? That is, I want the code related to stripping the text, to remain in the workbook, so that another user other than the one that created the function can use it. Any assistance would be appreciated. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
worsheet | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |