Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Calling Excel' 2007's "Yield" Functin From VBA?
10 views
Skip to first unread message
(PeteCresswell)
May 24, 2012, 12:59:19 PM5/24/12
to
Does anybody have a line of code that calls Excel 2007's Yield"
function from Access' VBA?
I was using Run for 2003, but 2007 broke that code.
For the "AccrIntM" function it was just a matter of changing Run
to WorksheetFunction, but Yield does not seem so amenable.
I've been beating my brains out for two weeks with Date() formats
and so-forth, but I can't make Yield happen from Excel 2007.
So, bottom line, can anybody post that magic line of code?
--
Pete Cresswell
function from Access' VBA?
I was using Run for 2003, but 2007 broke that code.
For the "AccrIntM" function it was just a matter of changing Run
to WorksheetFunction, but Yield does not seem so amenable.
I've been beating my brains out for two weeks with Date() formats
and so-forth, but I can't make Yield happen from Excel 2007.
So, bottom line, can anybody post that magic line of code?
--
Pete Cresswell
0 new messages