View Single Post
  #1   Report Post  
JIM.H.
 
Posts: n/a
Default Q: save a sheet to a file

I use ActiveWorkbook.SaveAs destFile in a macro to save current workbook to a
n excel file, how can I save only a specific sheet in current workbook to a
file?