Number to text

Closed
sudhir - Feb 4, 2010 at 05:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 4, 2010 at 06:23 AM
Hello,
I m very happy with the search but can we implement to all excel work book that the same formula come in the formula list without opening macro containing excel sheet.


Pls help...

Sudhir

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 4, 2010 at 06:23 AM
save your formula in a workbook and save it as "XLA", Put the excel file where the xla files are.

In vista it would be some where
C:\Users\rizvisa1\AppData\Roaming\Microsoft\AddIns\
Note: rizvisa1 is my user name. Yours would be different

in Xp
If would be
c:\documents and settings\rizvisa1\application data\microsoft\addin
Note: rizvisa1 is my user name. Yours would be different


you can find your path easily by looking at the value of Application.UserLibraryPath
0