Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Errors
Our department creates macros with VB (mostly in Excel)
and sends them to users across the country. Occasionaly, we have users who have used these macros for months without any problem and then all of sudden they get an error message. Most of these problems seem to occur with the Left and Right commands. They work for a long period of time. Then all of sudden there is an error. When we debug the issue, the highlighted word is Left or Right. We have begun using Mid instead and this doesn't seem to happen as much. (It also sometimes happens with "Cols". When we substitute Range for Columns the issue doesn't seem to happen as much also.) Following is an example of code we have used for months without any problem. YR = IIf(Dorder = 2, Left(Dtext, 2), Right (Dtext,2)) All of sudden some, but not all, users have started experiencing a "Compile Error: Wrong number of arguements or invalid property assignment". Has anybody experienced anything like this before? What causes this issue? Does a different machine setup (e.g., version of Excel, etc.) have any affect? Any information you can provide or if you can point us to any reference material to resolve this would be appreciated. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Errors
Usually this is because you have declared a variable using the function name
or declared a local function using a duplicate name. -- Regards, Tom Ogilvy "Thomas" wrote in message ... Our department creates macros with VB (mostly in Excel) and sends them to users across the country. Occasionaly, we have users who have used these macros for months without any problem and then all of sudden they get an error message. Most of these problems seem to occur with the Left and Right commands. They work for a long period of time. Then all of sudden there is an error. When we debug the issue, the highlighted word is Left or Right. We have begun using Mid instead and this doesn't seem to happen as much. (It also sometimes happens with "Cols". When we substitute Range for Columns the issue doesn't seem to happen as much also.) Following is an example of code we have used for months without any problem. YR = IIf(Dorder = 2, Left(Dtext, 2), Right (Dtext,2)) All of sudden some, but not all, users have started experiencing a "Compile Error: Wrong number of arguements or invalid property assignment". Has anybody experienced anything like this before? What causes this issue? Does a different machine setup (e.g., version of Excel, etc.) have any affect? Any information you can provide or if you can point us to any reference material to resolve this would be appreciated. Thanks for the help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Errors
This problem often occurs when a reference is lost to a library file.
The solution is to go into each of the machines where the problem occurs, in the VBE go to the ToolsReferences menu, and if you find any items in the list with 'MISSING' in them, click them to updater the link. What is happening is that the machines have different versions of software which manage to corrupt the links. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Thomas" wrote in message ... Our department creates macros with VB (mostly in Excel) and sends them to users across the country. Occasionaly, we have users who have used these macros for months without any problem and then all of sudden they get an error message. Most of these problems seem to occur with the Left and Right commands. They work for a long period of time. Then all of sudden there is an error. When we debug the issue, the highlighted word is Left or Right. We have begun using Mid instead and this doesn't seem to happen as much. (It also sometimes happens with "Cols". When we substitute Range for Columns the issue doesn't seem to happen as much also.) Following is an example of code we have used for months without any problem. YR = IIf(Dorder = 2, Left(Dtext, 2), Right (Dtext,2)) All of sudden some, but not all, users have started experiencing a "Compile Error: Wrong number of arguements or invalid property assignment". Has anybody experienced anything like this before? What causes this issue? Does a different machine setup (e.g., version of Excel, etc.) have any affect? Any information you can provide or if you can point us to any reference material to resolve this would be appreciated. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum everything but errors | Excel Worksheet Functions | |||
VALUE Errors | Excel Discussion (Misc queries) | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Any errors in this? | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |