| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Runs fine on my PC but errors on other PC's
VBA Runs fine on my PC but errors on other PC's How on earth do i find out WHY this is happening? as you can imagine, its frustrating as my code runs fine on my machine, so obviously i cannot find the errors... any ideas, help etc gratefully received (apart from using the other machines to develop on as not really convenient...) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
Does it say it can't find the project or library. Are the Versions of
Excel the same? If not, is the failing machine using an older version Imagine how frustrating for you to say it errors, but give no further explantion. (apart from using the other machines to develop on as not really convenient...) If they have an older version of excel, then you might need multiple copies of Excel installed on your machine. Would that be convenient? -- Regards, Tom Ogilvy wrote in message ups.com... VBA Runs fine on my PC but errors on other PC's How on earth do i find out WHY this is happening? as you can imagine, its frustrating as my code runs fine on my machine, so obviously i cannot find the errors... any ideas, help etc gratefully received (apart from using the other machines to develop on as not really convenient...) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
If they have an older version of excel, then you might need multiple
copies of Excel installed on your machine. Would that be convenient? actually - that might be it - i dont know what the error is as i have non-techy people using it, and do an error mess saying to contact me - but will try using an older version first..... thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
It is always best to develop on the oldest version of Excel which will use
the code. Also, references (tools=References in the VBE) are specific to each workbook. You should have as few references as you need - only things you have to references (like Excel, Office, Ole, and Perhaps MSforms). Also, if you recorded any code, this can be problematic with older versions, because Excel has added functionality to some core procedures. The added arguments in recorded code are unknown to older verions. In any event, you should install versions of excel/office in reverse order by age. You probably need to remover you current version and install the oldest you will use and move forward. -- Regards, Tom Ogilvy wrote in message ups.com... If they have an older version of excel, then you might need multiple copies of Excel installed on your machine. Would that be convenient? actually - that might be it - i dont know what the error is as i have non-techy people using it, and do an error mess saying to contact me - but will try using an older version first..... thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
Maybe an older non-compatible version of excel. I write a point of sale
program for a very large company where I must write in xl95 to accommodate all users. Some have even wondered why it didn't work at all and it turned out that they did not have any version of excel. -- Don Guillett SalesAid Software wrote in message ups.com... VBA Runs fine on my PC but errors on other PC's How on earth do i find out WHY this is happening? as you can imagine, its frustrating as my code runs fine on my machine, so obviously i cannot find the errors... any ideas, help etc gratefully received (apart from using the other machines to develop on as not really convenient...) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
Don Guillett wrote: ..... Some have even wondered why it didn't work at all and it turned out that they did not have any version of excel. ha ha ha - thanks, needed a laugh after my day!! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Runs fine on my PC but errors on other PC's
We'd need to see the specific errors you are encountering.
But probably, the other PC's have either different versions of Excel or different operating systems (Win2000 vs WinXP for example), resulting in different paths to the library or analysis references. On the PC it is not working on, go to VBA, Tools, References and look for anything that says "MISSING". I have had problems with "funcres", "atpvbaen" and "solver". These are fine on one PC but missing on another. I don't believe there is any solution for this. If there is I'd like to hear it. It is as if VBA hardwires the path to the references rather than dynamically finding them. -- Rev wrote in message ups.com... VBA Runs fine on my PC but errors on other PC's How on earth do i find out WHY this is happening? as you can imagine, its frustrating as my code runs fine on my machine, so obviously i cannot find the errors... any ideas, help etc gratefully received (apart from using the other machines to develop on as not really convenient...) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running | Setting up and Configuration of Excel | |||
| VBA errors in 2007 (works fine in 2003) | Excel Discussion (Misc queries) | |||
| Runs Fine In Step Mode But Crashes Excel Otherwise | Excel Programming | |||
| RPC ERROR - 1ST TIMES WORKS FINE - 2ND TIME ERRORS OUT | Excel Programming | |||
Linear Mode
