3.11 dialog

  • Thread starter Thread starter Jack Sons
  • Start date Start date
J

Jack Sons

Hi all,

I still use a "dialog" that originates from my W3.11 period. It is rather
complex and is in fact the central thing in my most important (home made)
extensive software. Luckily it stil works fine under XP and Excel 2000. Will
that also be the case with the newest available version and the coming
version of Excel? (which versions are they?)

Jack Sons
The Netherlands
 
I cannot tell from your post whether you're talking about Excel 4 or Excel
5/95 dialog boxes but both work fine in Excel 2003, the latest version.
Excel 4 dialog boxes depend on Excel supporting the old style Excel 4
macros. There is no guarantee that that support will continue indefinitely
and it's my guess we can only count on that for one more version at the
most.
 
Jim,

First of all, thanks for your "fast as lightning" answer.
Second, with W3.11 I used Office Professional, the suit with access and
excel.. Don't know wether it is E4 or E5, even don't know what the
difference is. I never had W95.
Excel 4 dialog boxes depend on Excel supporting the old style Excel 4
Click to expand...
macros.
Indeed, when I upgraded to W98 many of my macro's had to be addapted to the
new syntax. In W3.11 I think the macro's were in "Excel Visual Basic" and
Office Pro 98 used "Visual basic for Applications". Am I correct?
it's my guess we can only count on that for one more version at the most
Click to expand...
Do you mean that usually MS will announce with the release of a new version
wether the next version will no longer support an old feature, in this case
dialogs? In other words, if it works in the most recent version it will also
work in the next, unless it was stated otherwise when the recent version was
released?

Jack.
 
Just to be clear, Jack, there is no automatic connection between the Windows
version you're using and the Excel version. They are usually independent.
So to say you upgraded to Windows 98 doesn't tell us anything about what
version of Office/Excel you had.

The first version of Excel to use VB was Excel 5. It's true that two
versions later (Excel 97) MS started calling the it VBA instead of Excel VB
(since all of Office then supported it) but it was largely the same
language.

Anyway, since you started with Excel VB you were not using Excel 4. So I
think you can forget about the whole Excel 4 macro issue; it will not affect
you when MS drops Excel 4 macro support. So I know of no reason not to
expect that your application to continue to work with Excel for many, many
versions to come.
 
Back
Top