Run time error 52: Bad file name or number

[gamaz]

Hi,
I am having problem with a excel file generation using vba. This is happening to just one user. Could somebody say the possible reason of the error. I have not found any good solution for resolution. If it is permission what
do I need to do to allow more permission to the folder where the files are being opened and written into.
Thanks

[Richard Buttrey]

Hi,

Is the user given freedom to enter a path and filename or does the VBA macro mandate the file name?

Rgds

[gamaz]

Thanks Richard. Actually the user is not given the freedom to enter a path or a filename. Yes the Vba macro mandate the file name.

[Richard Buttrey]

Hi,

See if the following offers any help.

http://support.microsoft.com/kb/271513

There also appears to be various suggestions if you google: Excel File Save Permission

Rgds

[gamaz]

Thanks for your help again Richard. Does the dir function use on a folder assumes a particular permission on the folder. It seems the directory function
is creating the error.
Thanks.