Saving File
No.
I think that Geoff was suggesting that you get the guts of the code working
using an explicit path. Then when you change to that network path, you'll know
that the problem is either your spelling of that network path--or a network
problem itself.
Can you manually save a file to that location?
(Maybe it's a permissions thing.)
Richard wrote:
Geoff,
I was trying to avoid that, as it isn't a path that everyone has mapped. Is
that the only reliable method?
Richard
"Geoff K" wrote:
Try an explicit path ??
strFilePath = "C:\atkams\Credit Lists\"
hth
Geoff K
"Richard" wrote:
Hi
If I save my file "manually", using File, Save As, I get no issue. If I try
saving with the following code:
Sub SaveFile()
Dim strFileName As String
Dim strFilePath As String
Dim strYear As String
strYear = Worksheets("Dates").range("PrevWrkDay")
strYear = Format(strYear, "yyyy")
strFileName = "European Exchange Volume " & strYear & ".xls"
strFilePath = "\\atkams\Credit Lists\"
application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=strFilePath & strFileName
application.DisplayAlerts = True
End Sub
I get run-time error '1004':
cannot access 'filename'
What am I doing wrong.
Thanks in advance
Richard
--
Dave Peterson
|