Excel & CD

I've created a VB application that reads an Excel spreadsheet to fill out the label.  
Everything works until I burn it to a CD.

Here's what's happening:
1.  The CD starts up fine
2.  Click "Commercial" section, this reads an Excel spreadsheet and fills out the necessary labels
3.  Click on a label, this reads the same Excel spreadsheet and then opens a desired file          
     I get the following mesagges everytime: "A file named 'CommercialEnglish.xls' already exists in this location. Do you want to replace it?"
   
     If you click "YES" it works
     If you click "NO" it causes an error

Is there a way to automatically overwright without this prompt?
Thanks for the help.
eciabattariAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Mikal613Connect With a Mentor Commented:
Set xlApp = New Excel.Application
Set xlWb = xlApp.Workbooks.Open(“C:\Temp\temp.xls”)
Set xlWs = xlWb.Worksheets(1)

xlApp.DisplayAlerts = False  'Here it is
xlWB.Save
xlApp.DisplayAlerts = True
0
All Courses

From novice to tech pro — start learning today.