I really don't think there is much rewriting to be done. Most old code will
run fine in newer Excels Since I cannot reproduce the problem, as I
previously explained, I don't fully understand it. But I think that all
that would be required is copying the code from the Excel 95 versions of the
file to an Excel 97+ file.
--
Jim
| Hi Jim - yes, I agree it is something that should be available for
download,
| the error message that comes up in Office even tells you to download it
from
| Microsoft, but it isn't available. I saw those postings as well.
Possible
| we may just have to hire someone to rewrite the code again.
| --
| Chris Bean
| NYS Division of the Budget
|
|
| "Jim Rech" wrote:
|
| > I never heard of a VBA Converter Pack but apparently it's a real thing
(to
| > convert Excel 5/95 VBA modules to the Excel 97+) type:
| >
| >
http://support.microsoft.com/kb/926430/
| >
| > And apparently some people are unhappy that they can't just download it:
| >
| >
http://snipurl.com/3iehm [www_microsoft_com]
| >
| > But since I have Excel 95 installed I just created a workbook with code
and
| > it ran fine in Excel 2007 so I don't know what's going on.
| >
| >
| > --
| > Jim
| > | > | Did you try here
| > |
| > |
| > | Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint
2007
| > | File Formats
| > |
| >
http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
| > |
| > | --
| > | HTH
| > |
| > | Bob
| > |
| > | (there's no email, no snail mail, but somewhere should be gmail in my
| > addy)
| > |
| > | | > | > Hello - I have a program that has VBA code and Excel 2007 tells me I
| > need
| > | > to
| > | > install the vba converter pack from office online, but when I go to
| > office
| > | > online, it isn't there. Has anyone else had this problem and if so,
| > were
| > | > you
| > | > able to fix and how?
| > | >
| > | > Thank you so much!
| > | > --
| > | > Chris Bean
| > | > NYS Division of the Budget
| > |
| > |
| >
| >
| >
