<div>
Just change it to:<br />
Dim dlgSaveAs As Object<br />
<br />
That should do it.
</div>


Just change it to:
Dim dlgSaveAs As Object

That should do it.

<div>
check here<br />
<br />
<a href="http://www.mvps.org/access/api/api0001.htm" rel="ugc">http://www.mvps.org/access/api/api0001.htm</a><br />
<br />

</div>


check here

http://www.mvps.org/access/api/api0001.htm [http://www.mvps.org/access/api/api0001.htm]



<div>
when I subsitute object for FileDialog the first line passes but then the second line<br />
<br />
Set dlgSaveAs = Application.FileDialog( FileDialogType:=msoFileDia<wbr />logSaveAs)<wbr /><br />
<br />
fails<br />
<br />
Named argument not found. &nbsp;(FileDialogType is highlighted)
</div>


when I subsitute object for FileDialog the first line passes but then the second line

Set dlgSaveAs = Application.FileDialog( FileDialogType:=msoFileDialogSaveAs)

fails

Named argument not found.  (FileDialogType is highlighted)

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
&nbsp; I'm trying to use the File Dialog property to get input from a user to get the name and location to create a exported spreadsheet.<br />
<br />
&nbsp; I can export the spreadsheet fine. &nbsp;Here is the problem.<br />
<br />
&nbsp; Here is the code:<br />
<br />
Dim dlgSaveAs As FileDialog<br />
<br />
&nbsp; &nbsp; Set dlgSaveAs = Application.FileDialog( FileDialogType:=msoFileDia<wbr />logSaveAs)<wbr /><br />
<br />
&nbsp; &nbsp; dlgSaveAs.Show<br />
<br />
Here is the error - the Dim statement is where the error is happening<br />
<br />
Compile: &nbsp;Error<br />
<br />
User-Defined type not defined<br />
<br />
Can anybody help?<br />
<br />
Thanks in Advance
</div>
</div>


Hi All,

  I'm trying to use the File Dialog property to get input from a user to get the name and location to create a exported spreadsheet.

  I can export the spreadsheet fine.  Here is the problem.

  Here is the code:

Dim dlgSaveAs As FileDialog

    Set dlgSaveAs = Application.FileDialog( FileDialogType:=msoFileDialogSaveAs)

    dlgSaveAs.Show

Here is the error - the Dim statement is where the error is happening

Compile:  Error

User-Defined type not defined

Can anybody help?

Thanks in Advance

Need Help with FileDialog Property in MS Acess VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.