Error message on some computers

[mboro65]

Hello can anyone please help me

I have written an excel spreadsheet so others can complete provisional requirements and send them to me, where i compile them into a master register.
It is written in excel 2002, and is totally self contained, i.e it makes no external references, it is simply a userform and datasheets.
It works okay on my machine and some others, but there are machines that it brings up error "compile error in hidden module" (particulary a date field) and will not complete the task
All the machines are networked, built around same image
The only difference is that the machines where it won't work do not have Access 2002 installed. is this it??

Can anyone please help as this is beyond my capabilities
and I need to get it working
thanks

[K Dales]

Since you say the error has to do with a date field, I assume you know the
line of code that is giving the error - could you post it?
--
- K Dales


"mboro65" wrote:

>
> Hello can anyone please help me
>
> I have written an excel spreadsheet so others can complete provisional
> requirements and send them to me, where i compile them into a master
> register.
> It is written in excel 2002, and is totally self contained, i.e it
> makes no external references, it is simply a userform and datasheets.
> It works okay on my machine and some others, but there are machines
> that it brings up error "compile error in hidden module" (particulary a
> date field) and will not complete the task
> All the machines are networked, built around same image
> The only difference is that the machines where it won't work do not
> have Access 2002 installed. is this it??
>
> Can anyone please help as this is beyond my capabilities
> and I need to get it working
> thanks
>
>
> --
> mboro65
> ------------------------------------------------------------------------
> mboro65's Profile: http://www.excelforum.com/member.php...o&userid=33178
> View this thread: http://www.excelforum.com/showthread...hreadid=529973
>
>

[Jean-Yves]

HI,

Is your project protected ? So if you unlock the project first then run
your sub , where does it hang.
It could be a Regional settings problem (dot iso comma ?)
I have tested an xl sub using ADO to query an Access DB on a machine without
Access at home (office 2003 student version)
without any problem.
Regards
JY
"mboro65" <[email protected]> wrote in
message news:[email protected]...
>
> Hello can anyone please help me
>
> I have written an excel spreadsheet so others can complete provisional
> requirements and send them to me, where i compile them into a master
> register.
> It is written in excel 2002, and is totally self contained, i.e it
> makes no external references, it is simply a userform and datasheets.
> It works okay on my machine and some others, but there are machines
> that it brings up error "compile error in hidden module" (particulary a
> date field) and will not complete the task
> All the machines are networked, built around same image
> The only difference is that the machines where it won't work do not
> have Access 2002 installed. is this it??
>
> Can anyone please help as this is beyond my capabilities
> and I need to get it working
> thanks
>
>
> --
> mboro65
> ------------------------------------------------------------------------
> mboro65's Profile:
> http://www.excelforum.com/member.php...o&userid=33178
> View this thread: http://www.excelforum.com/showthread...hreadid=529973
>