View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default savecopyas saves as file type

Dave Peterson wrote:
MyNewFileName = Text1 & " " & Text3 & ".xls"


it worked, thanks a lot.......
but still wondering why the saveascopy didn't work.
thank you!
susan