View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
penni penni is offline
external usenet poster
 
Posts: 2
Default SaveAs macro in Excel

Is there a method of creating a macro that will initiate the worksheet to
SaveAs, specifically to a different network folder? I have a spreadsheet that
needs printing and saving to particular location, and the contents always
change. I have created the macro to print 2 pages of the worksheet but can't
figure out how to include that SaveAs piece. Many thanks.
--
Penni
Hillsborough, NC