Thread: Import macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gene Augustin Gene Augustin is offline
external usenet poster
 
Posts: 36
Default Import macro

I have tried and tried to get a certain macro to work from the Personal
Macro Workbook (PMW). It generates errors. On a lark, I created a module in
the current open workbook and pasted the macro there, and deleted it from
the PMW. The macro runs perfectly there.

Is there a way that I can create a PMW macro that will check to see it such
a macro exists in the current workbook and if it doesn't, access a text file
that contains the mis-behaving macro and paste it into a module in the
current workbook instead?

Gene Augustin