gregholl
asked on
still having troubles with an Excel Macro saving to C: on Windows 10
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)
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)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You just don't save any data into a root folder on C:. You need to save it to C:\Users\Public\Somewhere if it is used by different user accounts, or C:\Users\UserProfile\Somew here if it is only used by the current user account, or save it to another drive letter, as C: really should only ever be used for the OS:
You're welcome, Greg. Of course, rindi's comment represents good practice, but as we discussed at the previous question, you did not write the macro; you would rather not mess with it; and it works just fine on your old computer. So under the circumstances, writing to that folder is a reasonable approach, imo. Regards, Joe
ASKER