AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
Question I have written a code in VB for saving an excel file. But if I excute the same code once again, Excel (Naturally) asks me to replace the file. I want to open save as dialog box if file already exists with the same name.
Here is my code:
xl.ActiveWorkbook.SaveAs "C:\Temp\" & FRMLOGIN.eno & "-" & UCase(frmreport.mnt) & ".xls"
Answer looks like you are using VB 6.0, you need to use the "Dir" method to see if the file already exists, if it does then call the OpenDailog's ShowSave method to choose another filename or use a different path or filename to save the file. Dir function is the key.
