View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Prevent overwriting a file

Thank you

I get a Subscript out of range error with the code below highlighted. I
thought the problem might be that the type of file was not indicated (in
this case xlsm) so I tried adding before the last quote mark but I still got
the same error.


FileName = "P:\AA Exception\ " _
& Worksheets("ReliefBoard").[B3].Value _
& ", " & Worksheets("Relief Board").[D3].Value _
& "_Exception Sheet"