View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louise Louise is offline
external usenet poster
 
Posts: 217
Default VBA - Save with New Filename

Hi,

I have written some code and at the end I want my workbook to be saved with
an altered name, and then close the workbook.

i.e. the macro has finished running on previously saved file named "Test
File 2.xls", i want the end of my macro to call this file "Test File 2 -
altered.xls", and save it in the same location as the original file and then
close the workbook.

Any suggestions?

Thanks,