Previous Topic Next Topic

Number to text

Closed
sudhir - Feb 4, 2010 at 05:54 AM
rizvisa1
Posts
4479
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 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
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