• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Path/File access error on save

Gandalf

Gandalf

Member
Dear All

I am close to tearing my hair out on this one :mad:. I have an excel file with some, but not too much VBA which works fine until I save it to another drive, the copy gives me the error message so I go back to the original and that gives me the error message as well. On both copies the VBA listboxes are changed to normal text boxes following excels repairing process.

Has anyone had this problem or does anyone know a way round it before I lose the will to live and change sides to support Sauron!!

Thank you

Gandalf
 
I've not had such an issue, have you tried recreating the template by exporting theCVBA modules and forms to a new file? It may also be that the save drive itself may be corrupted or virused; or that the Path isn't recognized due to access issues. Have you used the ThisWorkbook.Path code?
 
Hi Chirayu

Thanks for your reply. I have tried exporting the VBA stuff to the copied workbook without success. The drive is a network drive so I don't think it is corrupted. I haven't tried the workbookpath code but I'll give it a go.

Thank you for your help and suggestions

Gandalf
 
You must log in or register to reply here.
Back
Top