Run time Error 75 - path/file access error

[EliV]

Dear All,

I've just started working with VBA. We have just finished writing some VBA program for interface purposes and it has been executing very good in 3 PCs running Window NT. Now when trying to run it in a HP vectra PC running Windows NT we are receiving the Run time error 75 - path/file access error.

The files are created in a directory in the drive C. In the program we define the full path:
"c\my directory\my file".
We have tried defining it, directly on the C drive with no success. We don't understand why it works ok in the other PCs and it is not working on this one. It must be something in the set up of the pc.

I would really appreciate some help. We have to have this up and running in this machine by this week.
Thanks in advance.

Eli

 

[monak]

If the path is correct and the file exists then check your server's security settings. If isn't that check if your are saving a file that is only read-only permissions.

 

[swisslog]

Is the save path "c\my directory\my file" or "c:\my directory\my file"? That is very different (Tanks to our old DOS friend!)

Try to start recording a new macro and do the save operation manualy. Then stop record the macro and read the code generated.

 

[EliV]

Hi all,
I will verify the server security settings. I'm guessing the problem must be in this particular server, because this same programa executes ok in three other PCs, but didn't know where to start looking for. The file being created is not read-only.
Sorry, but I mispelled the path. I'm actually using the path: c:\my directory\my file