View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Setting the default file name in the XLDialogSaveAs dialog box

Look at application.GetSaveAsFilename

the argument list is simpler. This returns the fully qualified name
selected - you then have to save the file with your code.

--
Regards,
Tom Ogilvy


Nelson wrote in message
...
I am writing a VB.Net program that dumps data to excel
2002. After I dump the data, I would like to have the
user chose where to save the file using the built in File
SaveAs dialog box. I can't make sense of the
argumentlist for this dialog. can anyone tell me how to
set the default file name?

Thanks!