H
Horus
Dear All!
I am new to this forum and quite new on programming Excel VBA as well
but here goes...
I am programming a module containing a Sub that employs th
application.filedialog object to get the path to a folder from th
user.
It works fine the first time I run it after starting Excel, but it hang
when I attempt it the second time. I use the Task Manager to close Exce
and get the message that "The system cannot end this program because i
is waiting for a response from you".
I think that I understand as much as that the filedialog object belong
to the Excel application as such and I guess it somehow persists betwee
my macro runs. I also assume that somewhere in my macro I am doin
something to change its state and cause it to malfunction the secon
time around.
I could post some code, but thought that a quick fix would be if it wa
somehow possible to reset or reload the filedialog object from scratch
I have not found such a possibility and to my surprise I have not bee
able to find any one else describing this issue on this or othe
forums.
Any help would be greatly appreciated
I am new to this forum and quite new on programming Excel VBA as well
but here goes...
I am programming a module containing a Sub that employs th
application.filedialog object to get the path to a folder from th
user.
It works fine the first time I run it after starting Excel, but it hang
when I attempt it the second time. I use the Task Manager to close Exce
and get the message that "The system cannot end this program because i
is waiting for a response from you".
I think that I understand as much as that the filedialog object belong
to the Excel application as such and I guess it somehow persists betwee
my macro runs. I also assume that somewhere in my macro I am doin
something to change its state and cause it to malfunction the secon
time around.
I could post some code, but thought that a quick fix would be if it wa
somehow possible to reset or reload the filedialog object from scratch
I have not found such a possibility and to my surprise I have not bee
able to find any one else describing this issue on this or othe
forums.
Any help would be greatly appreciated