Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried to
run the same on another machine it shows an error on every part of the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim. but
in my machine it works without

what would be the possible reasons?

thanks

Different versions of Excel?

--
Cheers
Nigel



"Abdul" wrote in message
oups.com...
Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried to
run the same on another machine it shows an error on every part of the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim. but
in my machine it works without

what would be the possible reasons?

thanks

Hi Abdul,

With the workbook in question active, run the problematic code.
When the code errors, go to the VBE and select the project in the Project
Explorer Window

Hit the reset button and look at the Tools | References list

Look for any references marked as "MISSING".

Either uncheck the reference or, if the reference is needed, try the browse
button to locate the library,


---
Regards,
Norman


"Abdul" wrote in message
oups.com...
Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried to
run the same on another machine it shows an error on every part of the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim. but
in my machine it works without

what would be the possible reasons?

thanks

Same version Office 2003 SP2 (11.8063.6568). May be some latest
updates will differ.
And it is installed using same CD (multi Licence). I am not quite sure
whether any components are missing. Most of the add-ins are same




Nigel wrote:
Different versions of Excel?

--
Cheers
Nigel



"Abdul" wrote in message
oups.com...
Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried to
run the same on another machine it shows an error on every part of the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim. but
in my machine it works without

what would be the possible reasons?

thanks

Thanks Norman, I did it and works fine



Abdul wrote:
Same version Office 2003 SP2 (11.8063.6568). May be some latest
updates will differ.
And it is installed using same CD (multi Licence). I am not quite sure
whether any components are missing. Most of the add-ins are same




Nigel wrote:
Different versions of Excel?

--
Cheers
Nigel



"Abdul" wrote in message
oups.com...
Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried to
run the same on another machine it shows an error on every part of the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim. but
in my machine it works without

what would be the possible reasons?

thanks

What did he want you to do ?

Seve


On Tue, 03 Oct 2006 11:14:36 +0100, Abdul
wrote:

Thanks Norman, I did it and works fine



Abdul wrote:
Same version Office 2003 SP2 (11.8063.6568). May be some latest
updates will differ.
And it is installed using same CD (multi Licence). I am not quite sure
whether any components are missing. Most of the add-ins are same




Nigel wrote:
Different versions of Excel?

--
Cheers
Nigel



"Abdul" wrote in message
oups.com...
Hello,

I have an application to show the sales data on a userform

when I run it on my machine everything works fine. But when I tried
to
run the same on another machine it shows an error on every part of
the
code having Format

And Also i havn't used option Explicit on my code but on the other
machine i found it for every variables i have define it using Dim..
but
in my machine it works without

what would be the possible reasons?

thanks

Hi Steve,

Thanks Norman, I did it and works fine

What did he want you to do ?

Check for missing library references - see my post for details.



---
Regards,
Norman