<div>
Some functions are changed in Excel 2007, and it's probably why your macro is not working. Sound like you will need to modify the coding, or record the macro again.
</div>


Some functions are changed in Excel 2007, and it's probably why your macro is not working. Sound like you will need to modify the coding, or record the macro again.

<div>
teylun is right, this should still work. &nbsp;Some known exceptions:1) FileSearch no longer works. &nbsp;It was killed in Office 20072) SaveAs now requires the file type argument, and some of the named constant values for the file types changed3) ChartObjects have some object model changes
</div>


teylun is right, this should still work.  Some known exceptions:1) FileSearch no longer works.  It was killed in Office 20072) SaveAs now requires the file type argument, and some of the named constant values for the file types changed3) ChartObjects have some object model changes

<div>
<div class="content wysiwyg-content">
Hi there, <br />
<br />
A client is using Microsoft Office 2003 and has a macro-enabled workbook, they want to share this with a user on Office 2007. <br />
<br />
When the user on '07 runs a macro button &quot;new day&quot; that populates a new page with formulas, none of the formulas are being copied as they normall should in '03. <br />
<br />
How can I make the spreadsheet compatible with more recent versions of Office?
</div>
</div>


Hi there, 

A client is using Microsoft Office 2003 and has a macro-enabled workbook, they want to share this with a user on Office 2007. 

When the user on '07 runs a macro button "new day" that populates a new page with formulas, none of the formulas are being copied as they normall should in '03. 

How can I make the spreadsheet compatible with more recent versions of Office?

How to use Macro enabled workbooks from Excel 2003 in Excel 2007

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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