?
Solved

VBA to Detect a Corrupt User Profile...

Posted on 2014-11-19
5
Medium Priority
?
172 Views
Last Modified: 2014-11-25
Hi All,

From time to time a corrupt user profile causes all sorts of issues in MS Word, see this EE question for example.

I'd like some help to detect corrupt user profiles using VBA, if there is a way...

Thoughts?
0
Comment
Question by:DrTribos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 97

Accepted Solution

by:
John Hurst earned 2000 total points
ID: 40454029
You do not know if a profile is corrupt until is does not do something you want. Office errors in damaged profiles are quite common. But the profile does not have an error flag saying "I am bad". Further, the Office errors can all be different. There is no one Office error or even one (say) Outlook error.

I am fairly sure you cannot do what you want in VBA or any programming tool.
0
 
LVL 15

Author Comment

by:DrTribos
ID: 40458987
Hi John,

Sorry the delayed reply - none of my computers would connect to EE, I don't know why but all other websites continued to work :-(

So I realize that MS don't have a flag saying "Oi! Hey You.... Yes you... I'm a corrupt profile"... BUT are there some characteristics of corrupt profiles that could be used to test against?

Perhaps different corruptions cause wildly different issues... perhaps there are some common themes... I'm not sure.  

I was thinking more along the lines of collecting as many of these characteristics as possible and creating a function to test how word behaves against the knowns...
0
 
LVL 97

Expert Comment

by:John Hurst
ID: 40459342
I have seen too many different issues and bad profiles are very common. If there was a list of errors, I think we would have seen them by now.
0
 
LVL 97

Expert Comment

by:John Hurst
ID: 40464320
@DrTribos  - Thank you and I was happy to assist, although I know you were looking for a different outcome.
0
 
LVL 15

Author Comment

by:DrTribos
ID: 40465853
No worries, I think it would be possible - perhaps onerous to compile a list of issues to test for but I now realise this is entirely the wrong forum to do so... I don't think EE has a mechanism for that type of activity.

Cheers,
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Know the reasons and solutions to move/import EDB to New Exchange Server. Also, find out how to recover an Exchange .edb file and to restore the file back.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

719 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