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 :
Set obook = nothing