Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to save excel gives msg about RESUME.XLS

Status
Not open for further replies.

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 .XLW file is an Excel Workspace

Hope This Help
PH.
 
A file named RESUME.XLW already exists, do you want to replace it"

Is there a way to stop the message appearing even though I have the codes "DoCmd.SetWarnings False" and "Application.DisplayAlerts = wdAlertsNone
" in the program?

Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top