Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Open file, hide window?

Status
Not open for further replies.

Brent113

Programmer
Aug 13, 2003
67
US
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
 
Set the Excel.Application.Visible property to False.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top