Create an Excel Report with a Button

[#1]

Hi Guys,

I wish to create a button on my spreadsheet that does the following :

Retains the current selections

Pulls specifc Field Names

Exports to excel.

I can build the "Report" within a Table Box, but I dont wish to have a tablebox sitting on the page ,

Can anyone advise or offer an alternative ?

Thanks

[m_woolf]

Build the report in a table box and hide the table box.

[#3]

Thanks Mwoolf

Do you know what is the best way to hide a table box ?

[m_woolf · Accepted solution]

Under Properties, on the Layout tab. Set a condition for showing the object. Probably best to create a variable something like: vShowTable = 'True' when you want to see the table and = 'False' when you want to hide it.