View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack Daniel Bonallack is offline
external usenet poster
 
Posts: 110
Default SaveAs Dialog box

I want to direct the user to save the file as a certain name, but the user
should to be able to browse the directory and choose where to save it.

For example, I want the user to have to save the file as "XYZ.xls". Can
someone provide the code that allows freedom on the save path, but not on the
file name?

Thanks in advance
Daniel Bonallack