View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimT TimT is offline
external usenet poster
 
Posts: 69
Default VBA for saving a file to a specific location

I'm using Excel 2003 and I'm recording a macro.
At the end of the macro I need to save the file to a specific location and
use the concatenation of two range names for the file name.
Does anyone know how the code should look like for this assuming:
location is "L:\Clients\symbol\"
range names are "month_entry" & "year_entry"
Please help!