Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Excel VBA UserForm file keeps crashing - RunTime Error 75

Posted on 2007-10-19
Medium Priority
Last Modified: 2008-03-05
Hello, I'm a little stuck! I am using Excel 2007 with a bit of VBA and have been dabbling in the wonderful world of User Forms. For some reason, if I open any worksheet which uses User Forms it seems to crash if it is left untouched for any period of time longer than about 2 minutes - often generating a Run Time error 75. I've tried re-installing Microsoft Office, but that doesn't seem to help. And I'm fairly certain the file (and code) is fine because I've tried the same file on other computers and it runs perfectly.

I don't know anything about improving performance, registry fixing or defragmenting, but from what I can gather, it might be something to do with that? If so, how do I go about sorting the problem so my Excel file doesn't keep crashing?

Thanks in advance for any advice people can offer.
Question by:ammo12kmf
  • 3
LVL 10

Expert Comment

ID: 20110493
Maybe you met a bug try on the Microsoft forum ...

:-( Janos
LVL 10

Expert Comment

ID: 20110612
75 Path/File access error - check the evtl path/filename

Author Comment

ID: 20113097
Sorry, what's the evtl file/pathname? Please bear in mind I'm completely ignorant about these things!
LVL 10

Expert Comment

ID: 20113842
75 is  Path/File access error - check the possible path/filename(s)
sorry for my mistake
LVL 26

Accepted Solution

EDDYKT earned 1500 total points
ID: 20129933
do you open file from the network?


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Rules and regulations were devised in order to maintain the integrity of a system. However, interpretation of rules can be quite tricky.
Conducting a customer service survey used to be as straightforward as sending a template email out using checkboxes and numerical rating systems to measure satisfaction.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question