K
kaldvelski
Hi all,
I have a line of VBA code that displays a file open dialog using the
Application.FileDialog(msoFileDialogOpen) object.
However, sometimes when I execute the .Show method I get a message box
saying "There is not enough memory or disk spec to complete the
operation".
I don't believe it really a hardware related issue as I'm not shot of
either RAM or HD space, but more curiously if I change the object to be
of type msoFileDialogPicker then it will display the dialog.
In fact the problem seems to be interchangeable between the two file
dialog types, i.e. they will both cause the problem at some point.
So does anyone know either
a) what might cause the problem in the first place?
b) something I could do in my code prior to calling Show to sort out
the memory?
I can't catch the error either to dynamically switch object types
because it seems to be raised by Word and not the VBA runtime.
TIA
Craig
I have a line of VBA code that displays a file open dialog using the
Application.FileDialog(msoFileDialogOpen) object.
However, sometimes when I execute the .Show method I get a message box
saying "There is not enough memory or disk spec to complete the
operation".
I don't believe it really a hardware related issue as I'm not shot of
either RAM or HD space, but more curiously if I change the object to be
of type msoFileDialogPicker then it will display the dialog.
In fact the problem seems to be interchangeable between the two file
dialog types, i.e. they will both cause the problem at some point.
So does anyone know either
a) what might cause the problem in the first place?
b) something I could do in my code prior to calling Show to sort out
the memory?
I can't catch the error either to dynamically switch object types
because it seems to be raised by Word and not the VBA runtime.
TIA
Craig