Hi There!
I am running into an issue with a code someone developed for me. They are not responding to me lately and would like to get this resolved.
I am not very well-versed in VBA and so I am reaching out to the community to help.
I am experiencing a Run-time Error 70 with the following script. It references to template files contained within the same folder. Any help that someone might be able to offer would be very much appreciated!
-Phil
Please Login or Register to view this content.
Not much anyone can do to diagnose the problem with no information. You would need to supply a sample workbook with the form(s) and code, together with the data file(s) that it processes.
The first question would be, what has changed in your environment? Have you changed the format of the file(s)? or their location? or the permissions on the file(s) and/or folder(s)? Permission Denied implies that you do not have, or no longer have, access to one or more of the files. I'm guessing that's not the workbook itself so that must mean you can't access the input file(s), or you are not permitted to create the output file(s).
At what point do you get the error? What line of code is being processed when you get the failure? What file is being processed? Can you step through the code and observe the values of any variables?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMS,
Thanks for responding. Please find attached the files in question. Unfortunately I cannot attach the template files because they aren't supported. I have attached the original documents that you could change to templates.B Report to a Prov Court Judge or the Court OCT 2014.docxA DNA Basic Documents Merge 2014-OCT-01 Sample.docA DNA Basic Documents Merge 2014-OCT-01 Endorsement.doc
To answer your questions:
Nothing has changed in my environment. The only thing that I did was add the Microsoft Office 14.0 object library in references. The documents have remained in the same folder the entire time.
An earlier version of this document was working just fine but has since also encountered the error 70.
I get the error code at
Just above the code in relation the document that the 00 DNA Database Master Copy V3(1).xlsmAttachment 446240Attachment 44624100 DNA Database Master Copy V3(1).xlsmAttachment 446240Attachment 446241spreadsheet is trying to access for that line.Please Login or Register to view this content.
It happens regardless of what line I select.
Any help you can give would be great!!
-Phil
These look like real names. If they are, I think you need to remove the examples.
They are actually all hockey player names. Not actually in relation to what we're doing hereOriginally Posted by TMS
OK, will try and have a look when I get a few minutes.
Just to save some time, have you checked that you can open files and/or create files (manually) in the location indicated byPlease Login or Register to view this content.
Yes, I can create, save and modify all files in that location
You said ...Why was that? The code uses Early Binding, that is, it refers to the Word Application rather than just an Object. Without the reference, the code would not compile and would not, therefore, execute. Have you changed from Excel 2007 to Excel 2010?The only thing that I did was add the Microsoft Office 14.0 object library in references.
Have you got any "Missing References" in your references list?
I have Microsoft Word 15.0 as missing
Guess that's the problem. If it's ticked you need to untick it and add Microsoft Word 14.0
I did uncheck it and then check Microsoft Word Object Library 14.0. That's when the run-time error appears
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks