Solved

still having troubles with an Excel Macro saving to C: on Windows 10

Posted on 2016-10-11
5
51 Views
Last Modified: 2016-10-11
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:
1
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:
2(It says: "Produbanco folder doesn't exist; please create it).

b) So I make the folder, as requested. No sub folder or anything.
3

c) Now I run the macro again, and it works just fine.
4
(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)
0
Comment
Question by:gregholl
5 Comments
 
LVL 69

Assisted Solution

by:Qlemo
Qlemo earned 100 total points
ID: 41839213
You might have to add full access for everyone in the folder's security tab (use the context menu on the folder to get there).
0
 
LVL 52

Accepted Solution

by:
Joe Winograd, EE MVE earned 400 total points
ID: 41839218
Hi Greg,
Yes, I'm still here. I think you're right that it's a security/permissions problem. First thing I would try is right-click on the folder in File Explorer (or whatever file manager you use), then click Properties, then the Security tab. In the top part of that dialog, click whatever group or user name you're using and then look in the bottom part to see if Write permission is checked. If not, log in as Admin and Edit the permissions to include Write. Regards, Joe
0
 
LVL 1

Author Closing Comment

by:gregholl
ID: 41839239
That was the ticket! All set now. thanks
0
 
LVL 88

Expert Comment

by:rindi
ID: 41839242
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\Somewhere 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:
0
 
LVL 52

Expert Comment

by:Joe Winograd, EE MVE
ID: 41839283
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
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question