Solved

Help with Excel VB Micro

Posted on 2014-11-24
1
131 Views
Last Modified: 2014-11-24
I am running excel 2013. I have an excel file that has a VB micro that converts the excel file to a text with fixed width. When i run the script i get an error and i cant figure out why its causing the error.  The code is attached and the highlighted area is line causing the error.
Scripted-Error.docx
0
Comment
Question by:miamitech305
1 Comment
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 40462235
If you have error 75, you have no access to root folder of drive c:. Try to add some folder and allow write access and change path to saved file to this folder
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

864 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now