uprichard
Programmer
- May 2, 2002
- 16
I have updated some cells within Excel workbook/sheet but when I issue a Save I get the following message
"A file named RESUME.XLW already exists, do you want to replace it"
My file name is "resource_list.xls" where does the above come from?
Here is my code
Set ExcelSheet = CreateObject("Excel.Application"
ExcelSheet.Workbooks.Open Resource_Filename
ExcelSheet.WorkBooks("resource_list.xls".Activate
' Uncomment below to see Excel app
'ExcelSheet.Application.Visible = True
For i = 0 TO UBOUND(Excel_Array)
ExcelSheet.ActiveWorkbook.Worksheets(Work_Sheet).Cells(Row_Number, i + 1).Value = Excel_Array(i)
Next
'save excel
ExcelSheet.Application.Save
'exit excel
ExcelSheet.Application.Quit
'Release the object variable.
Set ExcelSheet = Nothing
"A file named RESUME.XLW already exists, do you want to replace it"
My file name is "resource_list.xls" where does the above come from?
Here is my code
Set ExcelSheet = CreateObject("Excel.Application"
ExcelSheet.Workbooks.Open Resource_Filename
ExcelSheet.WorkBooks("resource_list.xls".Activate
' Uncomment below to see Excel app
'ExcelSheet.Application.Visible = True
For i = 0 TO UBOUND(Excel_Array)
ExcelSheet.ActiveWorkbook.Worksheets(Work_Sheet).Cells(Row_Number, i + 1).Value = Excel_Array(i)
Next
'save excel
ExcelSheet.Application.Save
'exit excel
ExcelSheet.Application.Quit
'Release the object variable.
Set ExcelSheet = Nothing