<div>
to solve the trust issue:<br />
<br />
File &gt;&nbsp;Options &gt;&nbsp;Trust Center<br />
<br />
click the Trust Center Settings command button<br />
<br />
on left sidebar: Macro Settings<br />
check --&gt; Trust access to the VBA project object model
</div>


<div>
Navigate to File Tab, and then click Excel Options--&gt; Trust Center --&gt;Trust Center Settings --&gt; Privacy Options.<br />
<br />
Clear the Check Office documents that are from or link to suspicious Web sites check box.<br />
<br />
and<br />
<br />
Navigate to File Tab--&gt; Options--&gt;Trust Center --&gt; Trust Center Settings --&gt; Trusted Locations.<br />
<br />
Click Add new location.<br />
<br />
Click Browse to find the folder you wish to add as trusted location, select the folder, and then click OK.
</div>


<div>
Was a simple case of removing the brackets to get the code to work.<br />
<br />
ThisWorkbook.SaveAs Pathfilename, xlExcel12
</div>


<div>
thanks, Jay, and you're welcome ~
</div>


<div>
<div class="content wysiwyg-content">
Experts<br />
<br />
I have a excel 2010 .xlsm workbook that I have a button on to &quot;export&quot; data. <br />
<br />
I am doing this by using the <br />
<br />
ThisWorkbook.SaveCopyAs (filename) <br />
<br />
Command and then removing the Sheets that are not required.<br />
<br />
The file saves ok but then when I try and open the export, when either xls or xlsx or csv I get an error saying that the file is &quot;in a different format than the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.<br />
<br />
I. was going to remove all macros code from ThisWorkbook to get around this but am struggling to do that too as I get a &quot;Programmatic access to Visual Basic Project is not trusted&quot;<br />
<br />
Sub removecode()<br />
ThisWorkbook.VBProject.VbC<wbr />omponents(<wbr />&quot;ThisWorkb<wbr />ook&quot;).Code<wbr />Module.Del<wbr />eteLines 1,ThisWorkbook.VBProject.V<wbr />bComponent<wbr />s(&quot;ThisWor<wbr />kbook&quot;).Co<wbr />deModule.C<wbr />ountofLine<wbr />s<br />
End sub<br />
<br />
Can someone help me with the logic or the code.<br />
<br />
Many thanks.
</div>
</div>


Experts

I have a excel 2010 .xlsm workbook that I have a button on to "export" data. 

I am doing this by using the 

ThisWorkbook.SaveCopyAs (filename) 

Command and then removing the Sheets that are not required.

The file saves ok but then when I try and open the export, when either xls or xlsx or csv I get an error saying that the file is "in a different format than the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.

I. was going to remove all macros code from ThisWorkbook to get around this but am struggling to do that too as I get a "Programmatic access to Visual Basic Project is not trusted"

Sub removecode()
ThisWorkbook.VBProject.VbComponents("ThisWorkbook").CodeModule.DeleteLines 1,ThisWorkbook.VBProject.VbComponents("ThisWorkbook").CodeModule.CountofLines
End sub

Can someone help me with the logic or the code.

Many thanks.

SaveAs Vba Excel 2010

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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.