Setting Default filename in Excel fileSaveAs Dialog

[nvmoss]

I am writing a VB.NET application that dumps data to Excel. After the dump, I want to prompt the user to save the file by showing the SaveFileAs Dialog Box. I am having trouble setting the default file name in the Dialog Box with the statement: Result = EXL.Dialogs(Excel.XlBuiltInDialog.xlDialogSaveAs).Show Argl:= fName VB.NEt indicates a syntax error (End of statement expected) The equivalent statement works in Excel, what am I doing wrong? Thanks! Nelson

[John Kuhn]

The syntax "Argl:= fName" shouldn't work in VB.NET. I believe that you simply pass the file name to the show method. Also, several people have written introductions to using Excel and Word in VB.NET and C#, you might try those if you have other problems.