Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving File
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
saving an excel file as an ASCII text file without delimiters | Excel Programming |