• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

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

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?
0
samfpt
Asked:
samfpt
1 Solution
 
WinsenCommented:
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.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
samfpt, normally Excel 2003 code should run just fine in 2007. Can you post the code for the button?

cheers, teylyn
0
 
Patrick MatthewsCommented:
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
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now