Path/File access error (Error 75)

%3CLINGO-SUB%20id%3D%22lingo-sub-3216838%22%20slang%3D%22en-US%22%3EPath%2FFile%20access%20error%20(Error%2075)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216838%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20an%20issue%20in%20my%20excel.%20So%20I%20have%20a%20build%20macro%20specifically%20for%20data%20organizer%20and%20cleaner.%20This%20is%20what%20I'm%20facing%2C%20Every%20time%20I%20upload%20the%20data%20file%20to%20do%20its%20things%20it%20starts%20the%20process%20and%20when%20its%20completely%20done%20it%20shoots%20me%20this%20error%20%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--2109735752%22%20id%3D%22toc-hId--2109735693%22%20id%3D%22toc-hId--2109735693%22%20id%3D%22toc-hId--2109735693%22%20id%3D%22toc-hId--2109735693%22%20id%3D%22toc-hId--2109735693%22%3EPath%2FFile%20access%20error%20(Error%2075)%3C%2FH1%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20after%20that%20nothing%20was%20successfully%20done%20and%20not%20operating%20at%20all.%20now%20i%20have%20use%20this%20same%20excel%20with%20other%20files%20with%20large%20data%20it%20works%20and%20with%20small%20amounts%20of%20data%20as%20well%20and%20it%20works.%20but%20recently%20it%20started%20shooting%20this%20error.%20i%20have%20read%20some%20forums%20on%20Microsoft%20on%20how%20to%20get%20this%20code%20resolve%20but%20I%20cant%20seem%20to%20fix%20it%20any%20help%20with%20some%20visual%20step%20by%20step%20scenarios%20to%20get%20this%20taken%20care%20of%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3216838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3216909%22%20slang%3D%22en-US%22%3ERe%3A%20Path%2FFile%20access%20error%20(Error%2075)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318625%22%20target%3D%22_blank%22%3E%40raymondsantos0106%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EA%20little%20more%20information%20would%20be%20helpful%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EVBA%20code%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EOperating%20system%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EOffice%20version%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EStorage%20medium%20(hard%20drive%2C%20Sharepoint%2C%20OneDrive%2C%20etc.)%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20I%20might%20guess%2C%20it's%20probably%20the%20path%20(in%20the%20entered%20variables%2C%20in%20the%20VBA%20code)%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Ethis%20must%20not%20start%20with%20%3CA%20href%3D%22http%3A%2F%2Fsharepoint%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fsharepoint%3C%2FA%3E...%2C%20but%20only%20with%20%5C%5Csharepoint%20...%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Ethen%20it%20should%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eit%20actually%20work%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E...If%20not%2C%20plese%20more%20information.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3216916%22%20slang%3D%22en-US%22%3ERe%3A%20Path%2FFile%20access%20error%20(Error%2075)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216916%22%20slang%3D%22en-US%22%3Ei%20have%20no%20idea%20what%20practical%20steps%20i%20should%20take%20to%20fix%20this%20issue%3F%20i%20am%20using%20excel%20and%20when%20i%20upload%20files%20to%20macros%20once%20it%20finishes%20give%20me%20this%20error%3A%20Path%2FFile%20access%20error%20(Error%2075)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

I am having an issue in my excel. So I have a build macro specifically for data organizer and cleaner. This is what I'm facing, Every time I upload the data file to do its things it starts the process and when its completely done it shoots me this error :  

Path/File access error (Error 75)

 

now after that nothing was successfully done and not operating at all. now i have use this same excel with other files with large data it works and with small amounts of data as well and it works. but recently it started shooting this error. i have read some forums on Microsoft on how to get this code resolve but I cant seem to fix it any help with some visual step by step scenarios to get this taken care of?

3 Replies

@raymondsantos0106 

A little more information would be helpful :).

VBA code? Operating system?

Office version?

Storage medium (hard drive, Sharepoint, OneDrive, etc.)?

 

If I might guess, it's probably the path (in the entered variables, in the VBA code),

this must not start with http://sharepoint..., but only with \\sharepoint ...

then it should it actually work

...If not, plese more information.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

i have no idea what practical steps i should take to fix this issue? i am using excel and when i upload files to macros once it finishes give me this error: Path/File access error (Error 75)

@raymondsantos0106 

I know it's annoying when software that is often used as a tool like Excel suddenly doesn't work.
It can be frustrating not being able to do your usual work.
I ask for your patience and understanding, as only you can see the problem and describe it to us.

Provide precise information about your digital environment in advance.
Which Excel version do you use?
What operating system does your PC have?
Where are the files stored (on your PC or on OneDrive or Sharepoint)?
Can you paste this macro you made?
"So I have a build macro specifically for data organizer and cleaner."
What do you mean by this statement?
Does this all only happen on this specific file?
Can you paste this file (without sensitive data) here?

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5