Hi Everybody,
I've created a code that allows me to select a excel file and open it (with application.getopenfilename) and copy some of the datas to my main workbook which has the code. I wanted to after necessary copying ends,it would automatically close the opened excel file but it shows an alert and I couldn't find how to remove it with a code. Can anybody tell me how to remove an alert automatically ? (I've tried Application.DisplayAlerts = False but it didn't work)
I've created a code that allows me to select a excel file and open it (with application.getopenfilename) and copy some of the datas to my main workbook which has the code. I wanted to after necessary copying ends,it would automatically close the opened excel file but it shows an alert and I couldn't find how to remove it with a code. Can anybody tell me how to remove an alert automatically ? (I've tried Application.DisplayAlerts = False but it didn't work)