View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dirk[_5_] Dirk[_5_] is offline
external usenet poster
 
Posts: 7
Default Insert into the Worksheet Menu Bar

I have a macro that will allow my users to export particular colomns
of a worksheet to a tab delimited file and I would like to insert a
"Save as Text" option in the "File" menu just after the "Save as..."
action. I was able to create a new menu option and add my macro to
that but I am stuck on how to insert it in the "File". I have tried
with the recorder but that did not work.

Any help will be appreciated.