MSGraph I hate you with passion!!!!!!!
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
Re: MSGraph I hate you with passion!!!!!!!
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