Reports output in Excel

[Gasman]

I will post back how it goes hiding the input sheet etc

FWIW I tried it out.

Put
xlWSh.Visible = True
after you select the sheet

and
xlWSh.Visible = False
just before you save it.

I did have a problem with the Range("A1") on the second run (not being able to be selected), so commented it out as did not need it at this point. I try and find out why later.

The reason for this code is when I hid the sheet in the template it became visible in the output file.

Edit: You do not need to set it visible each time. The code works on hidden sheets.

 

[blu_macey]

Greetings!

Sounds very useful to me, can I try this one?
Thank you very much, more power
Chino