<div>
Graham<br />
<br />
The 3rd argument of DoCmd.TransferSpreadsheet is for the name of the query you are exporting, is that query called 'File Name' or 'File_Name'?
</div>


Graham

The 3rd argument of DoCmd.TransferSpreadsheet is for the name of the query you are exporting, is that query called 'File Name' or 'File_Name'?

<div>
Norie, I get a Run-time error '2302' Microsoft access can't save the output data to the file you've selected.
</div>


Norie, I get a Run-time error '2302' Microsoft access can't save the output data to the file you've selected.

<div>
Graham<br />
<br />
It works for me albeit when saving to a folder with a different name.<br />
<br />
Have you checked the folder name/path?
</div>


Graham

It works for me albeit when saving to a folder with a different name.

Have you checked the folder name/path?

<div>
Stand by. I think I see what happened
</div>


<div>
Norie's suggestion will work.<br />
<br />
/gustav
</div>


<div>
I had the same file name and it was deleting the old spreadsheet link and that is why I got the error. I renamed the original file name and it worked. Thank you.
</div>


I had the same file name and it was deleting the old spreadsheet link and that is why I got the error. I renamed the original file name and it worked. Thank you.

<div>
<div class="content wysiwyg-content">
I am using Microsoft Access 2013 (I think) and I use DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm<wbr />l, <br />
&quot;File Name&quot;, &quot;C:\Detailed\MyView&quot; &amp;&nbsp;&quot;.xlsx&quot;, True,<br />
<br />
The workbook page names comes out as &quot;File_Name&quot; I need the space. Thanks for any help.<br />
<br />
Graham
</div>
</div>


I am using Microsoft Access 2013 (I think) and I use DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, 
"File Name", "C:\Detailed\MyView" & ".xlsx", True,

The workbook page names comes out as "File_Name" I need the space. Thanks for any help.

Graham

Excel Spreadsheet page name is coming out with _ not a space

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.