Why isn't there a property node for making a Workbook visible? There is for the entire Excel Application, and for individual worksheets, but I can;t find a property node to make a single workbook visible, leaving all other workbooks the same. I thought I could use the "sheets" property node from a Workbook, and then use its Property node to make them invisible, but its property node is a Variant type (?), and everything I've tried with putting in arrays of falses or single falses made into variant type gives errors.
What I'm trying to do is write to a workbook, but keep it invisible the entire process. I could make the entire application invisible; however, it is likely the user may have other Excel workbooks open that I don't want to make invisible, even during the 40 secs or so that the other workbook is being written to. Any ideas?
Michael