Open a book in the background

[Djblois]

I am currently using the code to open a workbook and get information from it. However, I want it to not be shown to the user. Can I open the book - automatically Hidden?

[VBA]Set wbRef = Workbooks.Open(sWorkbookToOpen)
wbRef.Visible = False[/VBA]

Thank you,
Daniel

http://studenthacker.blogspot.com/

[Bob Phillips]

Hide the window, not the book.

[Djblois]

Thank you XLD,

That is what I was doing first. Unfortunately it shows the book in the taskbar first then hides. I don't want it to show at all. Is that possible?

[Bob Phillips]

Not that I am aware of. Maybe set Ignore Other APplications temporarily.

[Djblois]

Xld,

you are not talking about Application.screenupdating are you? if that isn't what you are talking about please tell me how to do that?

Daniel

[Bob Phillips]

No I actually meant Windows in Taskbar, Tools>Options>View>Windows In Taskbar. Record a macro to get the code

[Djblois]

I will record the marcro but how do I find that on 2007 if you know? I just checked the View Tab Ribbon and I don't see it.

[Bob Phillips]

Click the Orange Office button

Click the Excel Options button

Select Popular from the left-hand menu pane

In the right-hand pane, click the 'Sow developer tab in the Ribbon' checkbox

record macro is then found in the Code Group of the Developer ribbon.

[Djblois]

No, sorry I know how to record a macro in Excel 2007. I don't know how to get to Tools>Options>View>Windows in Excel 2007.

[Bob Phillips]

Click the Orange Office button

Click the Excel Options button

Select Advancedf rom the left-hand menu pane

In the Display section of thr right-hand pane, click the 'Show all windows in the taskbar' checkbox

record macro is then found in the Code Group of the Developer ribbon

[tstav]

Hi Djblois,
1.Create a new instance of Excel
2.DO NOT MAKE IT VISIBLE
3.Open the workbook using this instance

[VBA]Sub HideOpenWorkbook()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
'xlApp.Visible = True
xlApp.Workbooks.Open "C:\1.xls"
End Sub
[/VBA]

From then on, for anything you will want to do with this Workbook, you're going to have to be using the xlApp just like it is used in the code to open the sample Workbook.

[tstav]

Also, remember after closing the Workbook, to remove the xlApp object because it's taking up memory
[VBA]
Sub HideOpenWorkbook()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open "C:\1.xls"
xlApp.Workbooks("C:\1.xls").Close False
Set xlApp = Nothing
End Sub
[/VBA]