Hi. I'm new here.
Anyone got any experience of Excel 2003 functions not working in Excel 2007?
I'm referring to VB functions, which have worked fine for years in XL2003. In XL2007 endless errors appear in the worksheets. Saving the workbook as .xlsm in XL2007 makes no difference.
The functions work fine in the .xls workbook providing the PC's had Excel 2003 installed on it in the past, and an upgrade to Excel 2007. But if the PCs had a fresh Windows/Excel 2007 build on it, the functions I'm using give errors. I'm not keen on a workaround/rewrite, as the file's 71mb, and has many worksheets and formulae - all of which would need double-checking. Microsoft don't appear to have anything on their site to help.
Thanks in anticipation.
What Functions do you mean?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Here's the Function - not written or altered by me so far. As I've said, it's run great for years in various previous versions of Excel, but now won't work on a PC that hasn't previously had Excel 2003 on it. It won't run in Excel 2007. It won't recognise CalcDate.
Again, thanks in anticipation.
(Thx Shg, updated with tags.)Function nrqtr(reviewdate) 'converts dates to nearest English quarter day calcdate = DateSerial(1900, Month(reviewdate), Day(reviewdate)) If calcdate >= 1 And calcdate <= 40 Then nrqtr = DateSerial(Year(reviewdate) - 1, 12, 25) ElseIf calcdate >= 41 And calcdate <= 130 Then nrqtr = DateSerial(Year(reviewdate), 3, 25) ElseIf calcdate >= 131 And calcdate <= 224 Then nrqtr = DateSerial(Year(reviewdate), 6, 24) ElseIf calcdate >= 225 And calcdate <= 316 Then nrqtr = DateSerial(Year(reviewdate), 9, 29) Else: nrqtr = DateSerial(Year(reviewdate), 12, 25) End If End Function
Last edited by RickyT; 06-18-2010 at 01:12 AM.
Ricky, please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Works fine for me in Excel 2007, although I'll admit I have no idea what it is supposedc to do.
OK he has added code tags so you can undelete my post now!
Ditto. Perhaps the VBE is set to require variable declaration, so declare calcdate, which would be good practice anyway.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks