07-03-2001, 04:05 PM
I have just created a VB application that basically manipulates data and produces a report in Excel. The report is created by openning up an existing report template (.xlt), enter the data and then saves it as an .xls file. The report comes out fine, but it is always hidden. So I always have to open up the workbook in Excel and select "Unhide" and then save it again. Any idea on how to prevent the workbook from being hidden in the first place?
07-04-2001, 11:43 AM
Is it just one of the worksheets that is hidden? - If it is - it can be unhidden by ...
Sheets("Sheet1").visible = true.
Hope this is of use.
05-23-2002, 10:24 AM
Thanks that worked. Sorry for the very delayed response.
Apparently all Microsoft files opened from a user's application are always hidden by default. So you just have to set the visible property to true, before you save it.
05-23-2002, 09:18 PM
This wins the award for the most delayed thank you ever on this forum. :D