Wanted to see if I could get some assistance. I'm trying to create a Macro that will Save my worksheet to a network share as a Macro Enabled worksheet with a file name based on the contents of Cell Value C5.
I'm relatively new to VB so be easy...I've searched around a little but can't really find what I'm looking for. Any ideas. I was originally trying to work with the below code, but keep getting compile errors.
Public Sub SaveAsC5()
ThisFile = Range("C5").Value
ActiveWorkbook.SaveAs Filename:="\\FileServ\Archive\" ThisFile
End Sub
Bookmarks