MSGraph I hate you with passion!!!!!!!

[i16978]

Hi to everyone!

This is not a VBA issue but closely related to VBA, so please hear me out.

I am working on application which generates bunch of msgraph charts of the XML file. All of this is build with .net and office 9 .

Currently I am working on a word output and here is the issue. I do not want to show the user the end document, until the generation is done, I do not want user to see any other applications besides the ones said user specifically called and here it is - MSGRAPH

For every chart I have a MSGRAPH window as i generate, which is usually 30 windows as well as my document becomes visible during the generation. I want to hide all of that, user can not see MSGRAPH or WORD until the program is done. There is got to be a way to do this

Thanks in advance


i16978

[sciguyryan]

If you are using a reference to the office components then all you need to do is set the Visible property of the ProgramName.Application to False

Cheers,

RyanJ