Personal.XLS Prob.
I have a family of macros and functions associated with a WB. I have now
created a subset of the WB's data into a new WB. The main processing macro is
large, and makes calls to a number of macros and functions.
I copied the Modules for all the associated macros and functions from their
original location to my Personal.XLS WB using Export and Import. Everything
is visible when I am in the VBA IDE, but when I make a call such as this:
Call Initializing.InitCodes(intK, blnCodes(), strSalaryOrHour, intWksCount,
strQualErnCd, intQualPeriod)
I get "Object required 424". Also when I do Alt-F8 the macros and functions
of the Modules in Personal.XLS do not appear to be listed (at least this one
isn't). After surfing around here I thought I had found my "AHA" moment when
one of the replies told a person who had queried with something similar, to
exit Excel and restart. Didn't work for me.
I'm willing to bet it's something truly trivial I am missing -- just can't
seem to think what it might be <g!
--
Dave
Temping with Staffmark
in Rock Hill, SC
|