I have this certain file from the Bank to do payroll stuff. I'm running Excel 2010 on a Windows 10 machine.
At the end of the process, I invoke a Macro that saves certain data to a folder on the C: Drive.
The macro always gives the following error:
I was able to create a work-around for this in EE post #28974910 (See https://www.experts-exchange.com/questions/28974910/having-troubles-with-an-Excel-Macro-saving-to-C-on-Windows-10.html
However, it have two files and the work-around didn't work for the second, because the VBA code is locked with a password.
This spreadsheet and macro was not made by me. This exact same Excel document works just fine on my old computer which was running Windows Server Edition 2012. I transfer the Excel file to the new computer under Windows 10, and the macro gets this error.
Here are some screen shots from the old computer:
The macro in question should save the text file that it generates to a folder called C:\Produbanco\
a) For this exercise I deleted the folder called C:\Produbanco\ just for this exercise. I try to run the Macro. I get this error:
(It says: "Produbanco folder doesn't exist; please create it).
b) So I make the folder, as requested. No sub folder or anything.
c) Now I run the macro again, and it works just fine.
(It says: "The Provider payment file was successfully created at C:\Produbanco\pagos fin sep.txt)
The macro works like this. I put in a certain cell the name I want the file to have. It this case, I entered the text: "pagos fin sep". Then a concatenate puts it all together and I get: C:\Produbanco\pagos fin sep.txt
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Now.... replay with this exact same Excel document, on the same version of Excel, but on the new computer and I get the error as shown above.
Hope that sheds some light to be able to troubleshoot this issue.
I'm suspecting that there is some kind of security issue going on that I cannot save to the C: drive. If so, please how can I circumvent that?
Thanks for your help! (Joe Winograd, are you there? hopefully we can continue with your previous ideas)