Thread: Save As Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Save As Macro

Hi,


I would like to put a button into a worksheet which will take the current
file and resave it into the users My Documents under the name of Tester. So
the file will always have the same name and be saved in the My Docs of
whoever is using the file.

This piece of the code is part of a larger code which will remove VBA,
formulas etc to make a smaller file.

Thanks
LiAD