Thread: Save As in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill D. Bill D. is offline
external usenet poster
 
Posts: 5
Default Save As in VBA


I want to put a Save AS button on a worksheet that will open the Windows
SaveAs dialog box so the user can select the path to where he wants the
worksheet saved. An inputbox will ask for the new file name prior to
opening the SaveAs dialog box.

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!