Run time error '1004'

[kaka4u]

Hi,

I am getting follwoing error while running below macro:


Microsoft Office Excel cannot access the file 'c:\Documents and Settings\Kaka\Desktop\Attachment_6\24\2011'. There are several possible reasons:

• The file name or path does not exist.
• The file is used by another program.
• The workbook you are trying to save has the same name as a

Macro

Sub SaveMe()
Dim fName As String
fName = Application.GetSaveAsFilename("Attachment_" & Date, FileFilter:="Excel Files (*.XLS), *.XLS", Title:="Save As")
ActiveWorkbook.SaveAs Filename:=fName
End Sub


Any help would be greatly appreciated.



Thanks

 

[Jonmo1]

Welcome to the board...

For 1 thing, that is not a file

'c:\Documents and Settings\Kaka\Desktop\Attachment_6\24\2011'

That appears to be only a PATH.
There is no .xls or any extention..


It would help to post the code as well..

 

[kaka4u]

Hi Jonmo1,

Thanks a lot for your quick reply. Your reply helped me to understand the problem and take action. Thanks once again.

kaka