Setting the default file name in the XLDialogSaveAs dialog box
 

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!

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!

Setting the default file name in the XLDialogSaveAs dialog box
 

Application.Dialogs(xlDialogSaveAs).Show arg1:="C:\my documents\test.xls"

is one way.


Nelson wrote:

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!

--

Dave Peterson

Setting the default file name in the XLDialogSaveAs dialog box
 

-----Original Message-----
Application.Dialogs(xlDialogSaveAs).Show arg1:="C:\my
documents\test.xls"

is one way.


Nelson wrote:

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!

--

Dave Peterson

.

Thanks Dave! I tried the following VB.NEt equivalent
statement, but it didn't work:

Result = EXL.Dialogs
(Excel.XlBuiltInDialog.xlDialogSaveAs).Show Argl:= fName

The Argl:= fName protion generated a syntax error
message - "End of statement expected".

there must be a difference in how this works from
VB.NEt. any suggestions?

Setting the default file name in the XLDialogSaveAs dialog box
 

No idea at all how .net works.

But xldialogsaveas has a constant value of 5.

So maybe (grasping way beyond my reach):
Application.Dialogs(xlDialogSaveAs).Show arg1:="C:\my documents\test.xls"
could be something like:

Application.Dialogs(5).Show("C:\my documents\test.xls")
or
Result = EXL.Dialogs(5).Show(fName)

If .net is like VBA, then you'll need to surround the fName with parentheses,
too.

In fact, that might be the only thing you need to fix!

(xldialogsaveas would be available for use if you had a reference to Microsoft
Excel in your program. If you use createobject() to start excel, then use 5.)


Nelson wrote:

-----Original Message-----
Application.Dialogs(xlDialogSaveAs).Show arg1:="C:\my
documents\test.xls"

is one way.


Nelson wrote:

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!

--

Dave Peterson

.

Thanks Dave! I tried the following VB.NEt equivalent
statement, but it didn't work:

Result = EXL.Dialogs
(Excel.XlBuiltInDialog.xlDialogSaveAs).Show Argl:= fName

The Argl:= fName protion generated a syntax error
message - "End of statement expected".

there must be a difference in how this works from
VB.NEt. any suggestions?



--

Dave Peterson