R
Robert_L_Ross
Ok, this is baffling me.
I worked with some of you on the newsgroup a while back to get some code to
enable a document template's drop-down box on a VB form to access a
spreadsheet to get the drop-down box values.
The code works fine (on four machines) but throws errors on 3 others:
System Error &H8000FFFF (-2147418113). Catastrophic Failure
In comparing the systems, I can't find anything that's different other than
virtual memory size (oddly enough, the systems with MORE virtual memory give
this error followed by an 'out of memory' error, while the systems wiht LESS
virtual memory run fine). When you change the virtual memory settings
(lowering the ones with the higher limits) doesn't fix the problem.
I've done a search on the web and found this question asked about a dozen
times but no-one can get an answer. Maybe some of the MVP's or even a
Microsoft person could decode this error and give me someplace to start?
I have the VB code in a text file if you'd like to see it, also the .dot
file and the corresponding .xls file that it searches.
Any help would be greatly appreciated!!
Rob (and crew).
I worked with some of you on the newsgroup a while back to get some code to
enable a document template's drop-down box on a VB form to access a
spreadsheet to get the drop-down box values.
The code works fine (on four machines) but throws errors on 3 others:
System Error &H8000FFFF (-2147418113). Catastrophic Failure
In comparing the systems, I can't find anything that's different other than
virtual memory size (oddly enough, the systems with MORE virtual memory give
this error followed by an 'out of memory' error, while the systems wiht LESS
virtual memory run fine). When you change the virtual memory settings
(lowering the ones with the higher limits) doesn't fix the problem.
I've done a search on the web and found this question asked about a dozen
times but no-one can get an answer. Maybe some of the MVP's or even a
Microsoft person could decode this error and give me someplace to start?
I have the VB code in a text file if you'd like to see it, also the .dot
file and the corresponding .xls file that it searches.
Any help would be greatly appreciated!!
Rob (and crew).