Thanks ever so much for your help Paul.
On Nov 16, 1:12 pm, Paul Schreiner wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
ActiveWorkbook.SaveAs Filename:=NewName, _
FileFormat:=xlExcel12, _
CreateBackup:=False
End If
End Sub
good luck,
Paul
- Original Message
> From: enquirer
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, November 15, 2010 1:34:10 PM
> Subject: $$Excel-Macros$$ AutoSa
Hello All
I would like to create a macro that will save the current workbook to
a subfolder on a mapped network drive (z:\master\CB), with a filename
the same as the contents of cell G7 (an autogenerated number).
I would like to automate this as much as possible, so if it can be
done automatically
