| || |
How to resolve Excel Sheet error?
Here the following Excel sheet code.
Set objExcelApplication = create object("Excel.Application")
objExcelApplication.worksheets ("Sheet1").Range ("A" & "1").value = "20"
When i execute the code fine.
when i try to excute the code second time with another row or the same row number. it show error
like " A file named "Resume.XLW" already exists in this location. Do you want to replace it. and the options are yes,no, cancel.
when i press yes its execute. when use no it shows another error like "Save method of applicaton class failed"
another resume file is created in "
C:\Documents and Settings\sv0012720\My Documents"
How to resolve this ?
Thanks in Advance
Re: How to resolve Excel Sheet error?
You are doing objExcelApplication.Save
That will try to save all the excel sheets that are currently open and thats why you are getting an error. I believe you are using to much short code. Better assign open workbook to an object and then do the operations. And dont ask how to do it, there are 100s of post lying out there with the required code. So better search it before asking again.