VBA from Excel 97 is not read by Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written some programs on numerical solutions of Differential Equations
based in EXCEL 97 and VBA.

They still work in EXCEL 2003 but when I try Excel 2007 beta the book is
read but NOT the VBA code that implements the numerical algorithms.

At least I have not been able to find the way to do it. And I need to, as I
have to access that code to include the function to integrate.

I am in a hurry as they will soon be published as part of a book on
Differencial Equations edited by Thomson.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...0468803&dg=microsoft.public.excel.crashesgpfs
 
I've had no problems running UDF's created in excel97 in excel2007.

Check your security settings. Excel2007 has a few more..
See BUTTON/Excel Options/Trust Center

see sections:
Macro Settings
Message Bar

For testing I've created a few trusted locations ..
e.g. DeskTop\Trusted

And you could add a Digital Signature to your workbook,
and add that Id to trusted Publishers.
(excel97 will ignore it)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Prof. Dr. Manuel Lopez wrote in
 
Back
Top