Sorry about the multi replies, the system said it was down and to try again later. Obviously it wasn't down.
I've now tried another approach, basically with the modules in a template and I'm now merging the sheet into the template and saving the file, thus avoiding the creating of the modules on the fly.
Works like a charm in Win XP Excel 2002, but Win 98 still causes invalid page fault.
My question - can I preserve the memory, or something, to make Win 98 happy?

"Amedee Van Gasse" wrote:

Janet Martin wrote:

I'm trying to copy modules from one Workbook to another using export
and import. I found some very helpful code on Chip Pearson's site
Programming to the Visual Basic Editor, thank you. Using Excel 2000
and Win 98.

Have you tried this in other Excel versions (XP, 2003) and on other
Windows versions (2000, XP, 2003)? Particularly Windows 98 is notorious
for its bad memory management. Which is what the error is about: Excel
trying to access an invalid memory page.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?

Please don't thank me in advance. Thank me afterwards if it works or
smack me in the face if it doesn't. ;-)