View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pflugs Pflugs is offline
external usenet poster
 
Posts: 167
Default Copying macro from word to excel

I have written a series of macros and functions in Word that transform a very
large text file into a delimited format that can be imported and formatted in
Excel. Once that data has been imported and formatted appropriately in
Excel, I want to copy a few modules of code into that spreadsheet so that the
user may run them when the macros are done.

Thanks to Chip Pearson, I am able to copy a full module, but I've noticed
that the module is visible from the "Macros" dialog box. I don't want the
user to try to run the macros meant for Excel from within Word, but I don't
know how to "hide" the macros so that they can't be run. My alternative now
is to run a function that generates a Long variable containing the text of
the Excel macros, but I want to know if there is an easier way.

Please let me know if clarification is needed, and thanks in advance.

Pflugs