View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ted Theodoropoulos Ted Theodoropoulos is offline
external usenet poster
 
Posts: 9
Default Compiling a workbook...

You dont need full blown Installshield type setup routine, a DOS batch
file would be fine or you could bypass that by writing a macro that calls
the
Shell function to run Regsvr32 and register your dll that way

Keith


Interesting. You couldn't do it in a macro in the workbook (VBA
project) that needs the dll could you? The project would have a
reference to the dll and that dll would not be present in which case
none of the code would work including the shell function to run
Regsvr32. How could you get around that?