Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Force Instantiation Of Excel 11?
20 views
Skip to first unread message
(PeteCresswell)
May 21, 2012, 8:39:41 PM5/21/12
to
I've got an environment where both Excel 11 and 12 have been
installed for a year or so.
Excel 11, however, was the default version.
But recently somebody's Excel app broke when the data exceeded
65,000 lines. Accordingly, The Powers That Be changed the
environment so that Excel 12 became the default.
That, in turn, broke my Access 2003 app that instantiated Excel
in order to use it's macros (specifically AccrIntM and Yield).
AccrIntM was no problem. I checked the version of Excel before
calling it and used "Run" for 11 and "WorkSheetFunction" for 12.
Yield, however, is not so amenable.
Bottom line: has anybody succeeded in forcing the instantiation
of Excel 11 when both are installed but 12 is the default?
I've tried CreateObject("Excel.Application.11"), but VBA seems to
ignore the ".11" and just instantiate the default.
--
Pete Cresswell
installed for a year or so.
Excel 11, however, was the default version.
But recently somebody's Excel app broke when the data exceeded
65,000 lines. Accordingly, The Powers That Be changed the
environment so that Excel 12 became the default.
That, in turn, broke my Access 2003 app that instantiated Excel
in order to use it's macros (specifically AccrIntM and Yield).
AccrIntM was no problem. I checked the version of Excel before
calling it and used "Run" for 11 and "WorkSheetFunction" for 12.
Yield, however, is not so amenable.
Bottom line: has anybody succeeded in forcing the instantiation
of Excel 11 when both are installed but 12 is the default?
I've tried CreateObject("Excel.Application.11"), but VBA seems to
ignore the ".11" and just instantiate the default.
--
Pete Cresswell
0 new messages