Hide second copy of Excel

[bdbBear]

Is there a way to hide a .xls file that is opened using Workbooks.Open?

After I open the .xls file from another .xls file it becomes visible; and I don't want it to be visble.

Thanks.

 

[combo]

Hide its window, manually: Window>Hide, by code: Workbooks(Index or Name).Windows(1).Visible=False.
However, the user can still unhide the window. You can make an add-in, this will keep all worksheet data, it still can be converted to regular workbook, but this requires some code.

combo

 

[bdbBear]

Thanks, though this doesn't seem to work.

Workbooks.Open (datafile)
Workbooks(datafile).Windows(1).Visible = False

On the first line, the file opens.
But then I get a "subscript out of range" error message on the second line.

 

[rmikesmith]

bdbBear,

If datafile includes a pathname, then your second line will generate the "Subscript out of range" error. You might try

ActiveWorkbook.Windows(1).Visible = False

Regards,
Mike