Excel Open file, hide window?

[Brent113]

Hi everyone, thanks for looking.

I am using VB6 (not vba) with the Excel com add-in, but since it's properties are shared, I was just curious if anyone here knew. I take a copy of the spreadsheet and move it to the Windows temp directory so the original can be opened by the user while my program accesses the slightly renamed copy.

My issue is that if the user opens the original, Excel windows for both the original and the copy are opened. Is there a way to hide the window for the temp spreadsheet my program is using?

____________________________________________________________________________
There are only 10 types of people in the world. Those that know binary and those that don't

Brent

 

[PHV]

Set the Excel.Application.Visible property to False.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Brent113]

Thanks for the quick reply, I have a question though.

Will that prevent the other excel windows from being shown too?

____________________________________________________________________________
There are only 10 types of people in the world. Those that know binary and those that don't

Brent

 

[combo]

If you need to change the visibility of worksheet's window, use:
YourWorkbookReference.Windows(1).Visible=True/False
(assuming that given workbook uses one window).

combo