Excel Workbook hides

[yogesh_gothe]

Hii,
I generate a report by opening a workbook and worksheet and some data. When no Excel file is previously opened then the report opens nicely, but when any file in excel is opened before clicking on report button then after clicking on report generate button, the report doesnt open , and if we go to the already opened file then Unhide if pressed then the report is opened in the new workbook which is desired. Why i have to Press the Unhide every time and cant i unhide via software.
Urgent matter.
Yogi

[hensa22]

try out this

Dim xls As New Excel.Application
xls.IgnoreRemoteRequests = true
.
.
.
.
.
.
xls.IgnoreRemoteRequests = false 'optional

I hope it's useful