Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
I have a spreadsheet that works fine on my pc but when other try to run it
they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
You don't give much detail. Excel versions??
-- Don Guillett SalesAid Software "Kevin" wrote in message ... I have a spreadsheet that works fine on my pc but when other try to run it they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
Sorry, Excel 2003 SP1.
Im waiting for one of the other guys to get in the office so I can see the exact error and give you an example. I know on one of them it complained about the use of Chr$(34). and in another spot is complained about the C in "for each C in MyRange". I'm guessing there is a preference set on mine that is not on theirs, I already checked the Variable declaration option to make sure it was the same as mine. "Don Guillett" wrote: You don't give much detail. Excel versions?? -- Don Guillett SalesAid Software "Kevin" wrote in message ... I have a spreadsheet that works fine on my pc but when other try to run it they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
Well, I think i found the problem. I'm not sure what the Chr$(34) is but I
dont seem to need it and its making it work on theirs to get rid of it... Also if I Dim C then it works... "Kevin" wrote: Sorry, Excel 2003 SP1. Im waiting for one of the other guys to get in the office so I can see the exact error and give you an example. I know on one of them it complained about the use of Chr$(34). and in another spot is complained about the C in "for each C in MyRange". I'm guessing there is a preference set on mine that is not on theirs, I already checked the Variable declaration option to make sure it was the same as mine. "Don Guillett" wrote: You don't give much detail. Excel versions?? -- Don Guillett SalesAid Software "Kevin" wrote in message ... I have a spreadsheet that works fine on my pc but when other try to run it they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
kevin,
I would suggest as a first step you confirm the references on the PC's that the coding is not working on. When missing references occurr it seems to lead to issues with string functions. Make sure none of the references are missing. 1. Press Alt-F11 2. Select Tools....References from the VBE Menu. 3. Make sure none of the references show MISSING. If this doesn't resolve the issue post back and let us know. HTH Cal "Kevin" wrote: Well, I think i found the problem. I'm not sure what the Chr$(34) is but I dont seem to need it and its making it work on theirs to get rid of it... Also if I Dim C then it works... "Kevin" wrote: Sorry, Excel 2003 SP1. Im waiting for one of the other guys to get in the office so I can see the exact error and give you an example. I know on one of them it complained about the use of Chr$(34). and in another spot is complained about the C in "for each C in MyRange". I'm guessing there is a preference set on mine that is not on theirs, I already checked the Variable declaration option to make sure it was the same as mine. "Don Guillett" wrote: You don't give much detail. Excel versions?? -- Don Guillett SalesAid Software "Kevin" wrote in message ... I have a spreadsheet that works fine on my pc but when other try to run it they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works on my pc but not others
YOU DA MAN!!!!! That did it. I had one reference not needed, removed it and
its working now. Thank you so much! "CBrine" wrote: kevin, I would suggest as a first step you confirm the references on the PC's that the coding is not working on. When missing references occurr it seems to lead to issues with string functions. Make sure none of the references are missing. 1. Press Alt-F11 2. Select Tools....References from the VBE Menu. 3. Make sure none of the references show MISSING. If this doesn't resolve the issue post back and let us know. HTH Cal "Kevin" wrote: Well, I think i found the problem. I'm not sure what the Chr$(34) is but I dont seem to need it and its making it work on theirs to get rid of it... Also if I Dim C then it works... "Kevin" wrote: Sorry, Excel 2003 SP1. Im waiting for one of the other guys to get in the office so I can see the exact error and give you an example. I know on one of them it complained about the use of Chr$(34). and in another spot is complained about the C in "for each C in MyRange". I'm guessing there is a preference set on mine that is not on theirs, I already checked the Variable declaration option to make sure it was the same as mine. "Don Guillett" wrote: You don't give much detail. Excel versions?? -- Don Guillett SalesAid Software "Kevin" wrote in message ... I have a spreadsheet that works fine on my pc but when other try to run it they get errors in certain modules. I ran it on my wifes pc last night, she has no add ins or anything and it worked fine. Any ideas where to look to find the issue? I have a company issued PC with the same install as others in the company, I have some extra add ins and thought that may be the issue but when it worked on my wifes at home with no add ins at all Im not sure where to look. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub works sometimes and sometimes doesn't | Excel Programming | |||
Excel Addin works that works on a template workbook | Excel Programming | |||
it works, it doesn work, its works....and so on. | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Works but... | Excel Programming |