I believe he means to determine the version number for the copy of Excel that
is running and taking 2 paths depending on what version you're using:

If Val(Application.Version) = 12 Then
'code for Excel 2007 (and presumably 2010) here
Else
'code for pre-2007 versions of Excel here
End If

Perhaps he meant to fork the code before it forks you?? Which it seems to
have already done.

"JLGWhiz" wrote:

'You have to fork the code'

Another technical term with which I am unfamiliar.



"Martin Brown" wrote in message
...
perf wrote:
Hi, I write because I'm experiencing a quite strange problem with Excel
2007 and
.xls file.
Time ago I created an add-in in vba that creates a toolbar that allows
depending on the chosen button to insert custom designs by me
(hysteresis, thresholds etc etc), and then connects these blocks together
with normal excel connectors. In Office 2003 everything was fine. Now I'm
having problems in 2007: to maintain compatibility with other PCs that
have Office 2003 installed on and must to work on files, I decided to
keep the format. xls as the default for all.
But there is a strange thing: when I open, in 2007, the xls files created
in office 2003 many blocks are 'moved' graphically (unpredictably), while
connectors are in place and go properly where it should be the blocks.
Moreover, as I try to
move the block, connectors move immediately.
If I move correctly the blocks and save the .xls file and reopen it, it
re-happens equal. in 2003 it's all perfect.
I hope I explained ...

Furthermore, if in 2007 I save the file as. xlsx after postioning
correctly the blocks,
the problem does not happen, and everything is perfect. I then tried to
open the .xlsx with a patched Office 2003, but then the problem is in
2003.

do you think that there is a solution to this problem? it seems that's
it's only a display mismatch.

The only solution to this problem involves the liquidation of the cowboy
development team responsible for the abortion that is XL2007.

Just about every aspect of shapes is made incompatible with all previous
versions. Top, Left, Bottom, Right changed to Top, Left, Width, Height.

Some objects will not draw correctly in XL2007 if they are closer to the
zero axes of the coordinate system. Charts are glacially slow.

You have to fork the code. It is possible to make an application using
graphical objects that will work in both the radically different choices
of parameterisation. However, forking the code is easier.

Regards,
Martin Brown


.