View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] uthra.r@gmail.com is offline
external usenet poster
 
Posts: 4
Default Help with SAVEAS

I need someones urgent help. Below is what i am trying to accomplish.
I want to send one of the sheets in the excel to a specific email
address. The sheet name should be constant. So I was saving the sheet
first as xyz.xls and then sending this excel. I want to give option to
the user to select the filepath.

I tried using GetSaveAsFilename but in this i want to hide the cancel
button and not let the user edit the filename. May I request someone
to help.

Thank you.