Hi,
Can I open the new Workbook in the invisible/hidden mode from an existing workbook using VBA (Workbooks.open).The Workbook is in on the same machine.I am using the following code :

Dim obook as Workbook
Set obook = Workbook.Open("FilePath")

but on executing the target workbook getting visible to the user.
I want the target workboook to be invisible/hidden, so that I can complete the required operations on it.
At last I m doing :

obook.close
Set obook = nothing

Use:

its working fine . thanx maccas