When the last excel instance that is closed had the 'Ignore other DDE application' checkbox set, then after closing it attempting to open any excel file from the browser will give a message saying that "There was a problem sending the command to the problem", even though the instance opens blank.
The immediate solution is in the blank instance use the 'open' command to open the new excel file (well not much of a problem as there is list of last opened excel files - clicking that will do). You may also notice that the 'Ignore other DDE applications' is still set in the opened instance.
So it throws light on point (2) of the last post. Excel remembers the setting of the last closed instance! Going by the kind of logic I usually follow in my code this should happen if there is no default setting - so where is it?
The immediate solution is in the blank instance use the 'open' command to open the new excel file (well not much of a problem as there is list of last opened excel files - clicking that will do). You may also notice that the 'Ignore other DDE applications' is still set in the opened instance.
So it throws light on point (2) of the last post. Excel remembers the setting of the last closed instance! Going by the kind of logic I usually follow in my code this should happen if there is no default setting - so where is it?
No comments:
Post a Comment