Through my application I am setting the DefaultFilePath for the excel application so that the worksheets currently active will default to specific folder when the user tries to save the excel file manualy.
The issue I am facing is that the DefaultFilePath is not set for current/active excel application. It set only when the excel application is opend for the second time.
I want the DefaultFilePath to be effective with the active excel application. Please let me know how to accomplish this.