I know it can be done ... but how ???
-
I am facing very simple problem (i alreday overcome from this problem before but at the moment i am unable to find the way ;P) Problem is I am writting(saving) a excel file from program ... before saving the file i open a "ShowSave" dialog from which i am taking the file name from it ... ( the dialog box prompt for ALREADY EXISTS file .. if any) ... but when i am finally going to save the file from "WorkBook.SaveAs" Microsoft Excel againg prompt from Overwrite message. I want to avoid this "OVERWRITE Message" :-D ... since i already asked from user before ... I know this can be done (since i already done this VC long time ago :(( ) but how ... Please help ... Any word, code, sample, web site, any thing will help me lot Thanx to all in advance
-
I am facing very simple problem (i alreday overcome from this problem before but at the moment i am unable to find the way ;P) Problem is I am writting(saving) a excel file from program ... before saving the file i open a "ShowSave" dialog from which i am taking the file name from it ... ( the dialog box prompt for ALREADY EXISTS file .. if any) ... but when i am finally going to save the file from "WorkBook.SaveAs" Microsoft Excel againg prompt from Overwrite message. I want to avoid this "OVERWRITE Message" :-D ... since i already asked from user before ... I know this can be done (since i already done this VC long time ago :(( ) but how ... Please help ... Any word, code, sample, web site, any thing will help me lot Thanx to all in advance
I got it ... it is X| AppExcel.DisplayAlerts = False Thanx for all But there is one more problem i am facing and this is when EXCEL.EXE is still in running condition, even i close the Application. I check it through Task Manager. For closing the Excel Application I use following code. AppExcel.DisplayAlerts = False wBook.SaveAs FileName:=strFileName, FileFormat:=xlNormal, ConflictResolution:=False Set wSheet = Nothing Set wBook = Nothing AppExcel.Quit Set AppExcel = Nothing After last line i check the Task Manager ... their is still a EXCEL.EXE running .... How i resolve this ... Again thanx in advance