INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Excel Form - Compile error in hidden module.

Excel Form - Compile error in hidden module.

(OP)
Hello Guys:

Please i need your support.

I have developed a tool in excel containing a FORM saving data to a SQL server database. Everything is working smoothly when I test the tool in my network with many users simultaneously.

My problem begins when I test the tool with remote users. I have defined a UNC link \\fsho01.sguc.ad\apps\Tool\Form.xlsm in order to the users can open the tool performing the data entry in the form and save it. Remote users get this error msg "Compile error in hidden module this error commonly occurs when code is incompatible with the version,platform or architecture......"

Users use the same excel version (2010) like the tool, The shared Excel object (The tool) includes all this references and libraries.

Somebody can help me? I will appreciate any suggestion or advice.

Thanks in advance

GonFer



RE: Excel Form - Compile error in hidden module.

If you have password-protected vba project (error message indicates this), try to test distribution with unprotected code for trusted user.

combo

RE: Excel Form - Compile error in hidden module.

This one is going to be interesting to watch...

they all have Excel 2010 (most likely everybody is using Win7pro? [at least?])

the remote user's AV aren't mentioned (some of those are such sticklers for TCP and Identity issues)

did you try this from your house? (better control/access to hardware and know your own setup)

guessing the database is online and write-to is allowed? ("...saving data to a SQL server database.")

--MiggyD

"If a tree falls in the forest and no one is around, does it make a sound?" I finally got the answer!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close