N
Neal Zimm
Hi All,
Am developing an App where user's Wbk references an AddIn.
Data in AddIn sheets control options available to users.
Some of this data becomes arrays in a User record and I use the
AddIn object a lot for lookups.
Record is updated in a bunch of different Sub's and Functions.
Public Type uOptRec 'there are more fields, about 20. a few to illustrate
iMthDaysAy(12) as integer 'Qty of days in month
iMidMthDay(12) as integer 'day of midpoint in month
bExpenseAuth as boolean 'expense authorization yes/no
AAscAddIn as workbook 'where the data is stored
End Type
I'm not a super techie and don't know the "cost" of putting a
workbook object in a user record.
It seems easy to put the AddIn in the record versus:
Sub UpdateA(AAscAddIn as workbook, uOptRec as uOptRec, ..........
to minimize the arguments in the sub/function statement.
Bullen's book says "keep them to no more than 5, usually ... "
But, is it efficient ???
Does a workbook object in a record take up a lot of computer resources?
Is it anything like a "copy" of the .xla file IN the record ?
What are the Pro's and Con's ?.
Thanks, Neal Z
Am developing an App where user's Wbk references an AddIn.
Data in AddIn sheets control options available to users.
Some of this data becomes arrays in a User record and I use the
AddIn object a lot for lookups.
Record is updated in a bunch of different Sub's and Functions.
Public Type uOptRec 'there are more fields, about 20. a few to illustrate
iMthDaysAy(12) as integer 'Qty of days in month
iMidMthDay(12) as integer 'day of midpoint in month
bExpenseAuth as boolean 'expense authorization yes/no
AAscAddIn as workbook 'where the data is stored
End Type
I'm not a super techie and don't know the "cost" of putting a
workbook object in a user record.
It seems easy to put the AddIn in the record versus:
Sub UpdateA(AAscAddIn as workbook, uOptRec as uOptRec, ..........
to minimize the arguments in the sub/function statement.
Bullen's book says "keep them to no more than 5, usually ... "
But, is it efficient ???
Does a workbook object in a record take up a lot of computer resources?
Is it anything like a "copy" of the .xla file IN the record ?
What are the Pro's and Con's ?.
Thanks, Neal Z