I recently coded a spreadsheet which creates subsets of
data which are then saved separately. After cutting the
data I use the statement below to save the data:
& thisfilename & ".xls", _
However, the problem I have is that excel keeps stopping
at this command to get confirmation that it's okay to
overwrite an existing file with the same name with the new
is there anything I can put in the code that effectively
stops excel checking to see if the filename already exists?
Thanks in advance for any postings.