Is there a way to get a macro to work in 2013 that was previously working in 2010? The code for the spreadsheet was working and after an upgrade to 2013 I'm getting a "runtime error '5': Invalid procedure call or argument". I checked references and it doesn't show any missing libraries.
It's not realistic to do. Joke!
Show the file with the error and explain how to work with him.
To do it for me and help me it is 2 different things!
Sorry for my english, blame Google translator
I'm trying to modify code done by someone else. The error code shows up for the highlighted line.
Last edited by TLeng; 08-15-2016 at 11:50 AM. Reason: Can't get a file to attach.
Hi,
What is the highlighted line?
Don
Please remember to mark your thread 'Solved' when appropriate.
Tried to attach a word document and a text file. Will hopefully have it figured out so that I can attach the file.
It is easy to post the code in a post rather than as an attachment.
It's a little long. The line with the issue is in red below.
Please Login or Register to view this content.
I would check for valid arguments just before your instruction that makes the error.
Try this just before the red line…
This will show the text being used and its length, which should be at least 4 characters in order for the instruction in red to work.Please Login or Register to view this content.
If the length is less that 4 characters, then use a different calculation, for example…
This leaves strResult unchanged when it is very short. Adjust the alternate action as needed.Please Login or Register to view this content.
Hope this helps.
If this has been helpful, please click on the star at the left.
Thank you for the guidance on this. I found out there wasn't anything being returned for the value and that lead to looking at the website that the code was pulling information from. The website changed some of the references on the site, so I can hopefully update that and get the code to work.Originally Posted by StuCram
I would check for valid arguments just before your instruction that makes the error.
Try this just before the red line…
This will show the text being used and its length, which should be at least 4 characters in order for the instruction in red to work.Please Login or Register to view this content.
If the length is less that 4 characters, then use a different calculation, for example…
This leaves strResult unchanged when it is very short. Adjust the alternate action as needed.Please Login or Register to view this content.
Hope this helps.
Glad to have helped a bit.
Best wishes.
PS - Be sure to mark this thread as 'Closed' now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks