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...)

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...)

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

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

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...)

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!!

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...)