saving file as cell A1 to location other than default

[jpettit]

I borrowed the code for the simple "saveasA1", and put in a different path other than the default location. when i run the marco it is say location not found, etc. Do i have the syntax correct for the network path directory? If so, what else could be stopping the save?

Public Sub SaveAsA1Again()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs FileName:="\\cs2data1\eesdwwshared\30Day\" & ThisFile
End Sub

 

[RWinfield]

On 2002-02-21 15:35, jpettit wrote:
I borrowed the code for the simple "saveasA1", and put in a different path other than the default location. when i run the marco it is say location not found, etc. Do i have the syntax correct for the network path directory? If so, what else could be stopping the save?

Public Sub SaveAsA1Again()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs FileName:="\cs2data1eesdwwshared30Day" & ThisFile
End Sub

try this

FileName:="\cs2data1eesdwwshared30Day" & ThisFile & ".xls"

Rick

 

[jpettit]

thanks very much...this works