B
Brent E
Good Day,
I am using macros in an Excel file perform sorts on data and save each sort
type as a seperate html file. I want to be able to use this macro to perform
automatic updates.
If I use the Workbook.SaveAs command, I am constantly prompted whether to
overwrite the existing file. I do not want this box to appear.
Is there a variant to the Workbook.SaveAs command that automatically
overwrites a file with the same file name without prompting for a
yes/no/cancel?
Thanks,
I am using macros in an Excel file perform sorts on data and save each sort
type as a seperate html file. I want to be able to use this macro to perform
automatic updates.
If I use the Workbook.SaveAs command, I am constantly prompted whether to
overwrite the existing file. I do not want this box to appear.
Is there a variant to the Workbook.SaveAs command that automatically
overwrites a file with the same file name without prompting for a
yes/no/cancel?
Thanks,