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
|