+ Reply to Thread
Results 1 to 3 of 3

Access a UDF in an xlsx file

  1. #1
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Access a UDF in an xlsx file

    Is there any way to reference a user defined function in an xlsx file?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,767

    Re: Access a UDF in an xlsx file

    There are a couple of ways to do this. Where is your UDF defined? If the code is in PERSONAL.xlsb, then it will always be available to your xlsx file.

    You can put the code in a .xlsm file and convert it to an add-in. This requires the add-in to be installed.

    Who will use the file? If you want to give your file to another user then it's a bigger problem.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Access a UDF in an xlsx file

    Thanks for the help. The file is used primarily by someone else, but I didn't want them to have to change the file references (not such a big deal).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-23-2022, 04:02 AM
  2. [SOLVED] with this macro I can't insert the file format xlsx, only xls but I need format xlsx
    By torti111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2016, 04:45 AM
  3. Help with code to convert xls to xlsx and continue with xlsx file
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 11:47 AM
  4. lock file created to allow share access to xlsx??
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2014, 11:05 AM
  5. Replies: 3
    Last Post: 01-05-2014, 05:50 AM
  6. Replies: 4
    Last Post: 10-23-2013, 12:54 AM
  7. How to add the columns data of several xlsx files of a folder in another xlsx file
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-25-2012, 04:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1