Vba excel path file access error

Any path that isn't fully qualified is relative to the current drive and directory. You attempted to save a file that would replace an existing read-only file.

Change the read-only attribute of the target file or save the file with a different file name. You attempted to open a read-only file in sequential Output or Append mode. Open the file in Input mode or change the read-only attribute of the file.

You attempted to change a Visual Basic project within a database or document. You can't make design changes to the project.

Have questions or feedback about Office VBA or this documentation? Just a guess but if your system has changed which is why you have now the file permissions for access to the root drive may have changed.

It's not uncommon for C: to be reserved to administrative users. Maybe test with a log file in another location? Hi xenou ; Thank you for your reply and good to hear from you! Please try the suggestion and then we can continue if it doesn't work. Hi xenou ; Maybe test with a log file in another location? I can't really explain why you can create files on C: otherwise, but not in code.

It must be a security protocol related to protection against malicious scripts - I've been in a few situations where I couldn't write to the C: drive so I just avoid it anymore. You must log in or register to reply here. Similar threads D. Replies 12 Views MajorFudge69 Nov 12, Excel Questions. Replies 1 Views Nelsini Oct 19, Excel Questions. Replies 8 Views Oct 20, Nelsini. Collectives on Stack Overflow. Learn more.

Asked 4 years, 6 months ago. Active 4 years, 6 months ago. Viewed 2k times. Looking at the code below I get a path file error on the line - Open inFile For Input As 1 Having debugged I can see that the file name stored in strFile disappears when the second routine is called. Dyhouse Dyhouse 93 4 4 silver badges 14 14 bronze badges. Please read this: stackoverflow. Robin Mackenzie, I have updated the code, I hope it is within the guidelines a little better now — Dyhouse.

Robin Mackenzie The value is of strFile is picked up in the first sub routine as part of the Save As for the initial text file that is created but when it is picked up in the second routine it disappears Show 1 more comment. Active Oldest Votes. Add a comment. Sign up or log in Sign up using Google.