| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Public Function From Workbook Module to XLA
When I'm developing a UDF, I'll put it in a test workbook. Then take as much
time as I need to get it running there. When it's working perfektly(!), I move it to its real home and just delete that test workbook file. If I need to test the UDF in a cell in a real workbook, I'll just fully qualify it: =testworkbooknamehere.xls!myfunct(....) Bruce wrote: You are a genius, it worked great. The good thing about this solution is that it's trivial to do. It's hard to explain but I'd like to be able to do this 'move' somewhat regularly. Thanks, Bruce -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
| compiler error: public object module | Excel Programming | |||
| How to add a public subroutine to a class module | Excel Programming | |||
| How to reference a public array (declared in module) from a proced | Excel Programming | |||
| Passing Public Module Vairable to a Worksheet Event | Excel Programming | |||
Threaded Mode
