VBA compatibility from Vista to Windows 7

[henry.chadwick]

Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I am having difficulties running a VBA reporting tool on windows 7, originally built on vista. The VBA version (6.5) and excel (2007) are both unchanged - only the operating system has changed..
<o> </o>
I did not design the tool so my understanding of the specific code is not great. However, I have identified the problem to be related to VBA not recognising the following functions: CHR() or Format ().
<o> </o>
Does anyone know if these are no longer supported or if alternative functions are available that do the same thing?<o></o>
<o> </o>
Also I have found that VBA now seems to require all variables to be defined using ‘Dim’ when in Vista they would not have to be.<o></o>
<o> </o>
Can anyone explain?
<o> </o>
Many thanks in advance.

 

[VoG]

For the first one, check for missing references http://www.cpearson.com/excel/MissingReferences.aspx

For the second, Tools > Options, untick Require Variable Declaration. However, it is not a good idea to do that.