<div>
Not tried that but did just stumble across another thread which works a treat...<br />
<br />
<a href="https://www.experts-exchange.com/questions/20658116/Export-ASP-to-EXCEL.html" rel="ugc">https://www.experts-exchange.com/questions/20658116/Export-ASP-to-EXCEL.html</a><br />
<br />
Will award you the points for your time and will test your code tomorrow.
</div>


Not tried that but did just stumble across another thread which works a treat...

https://www.experts-exchange.com/questions/20658116/Export-ASP-to-EXCEL.html [https://www.experts-exchange.com/questions/20658116/Export-ASP-to-EXCEL.html]

Will award you the points for your time and will test your code tomorrow.

<div>
<div class="content wysiwyg-content">
I'm using classic VBScript to write a page out to Excel however the worksheet that is created has the standard Excel gridlines disabled. I've found a few threads that suggest this can be controlled and enabled in my output however none of the threads offer a concise or functioning piece of code to do this.<br />
<br />
To be clear, I am not seeking to apply borders to my output data in Excel, but instead I want to enable the gridlines that usually appear by default across the entire worksheet and not just where my data appears.
</div>
</div>


I'm using classic VBScript to write a page out to Excel however the worksheet that is created has the standard Excel gridlines disabled. I've found a few threads that suggest this can be controlled and enabled in my output however none of the threads offer a concise or functioning piece of code to do this.

To be clear, I am not seeking to apply borders to my output data in Excel, but instead I want to enable the gridlines that usually appear by default across the entire worksheet and not just where my data appears.

ASP to Excel show gridlines

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.