ASP to Excel show gridlines

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.
LVL 9
guswebbAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NicksonKohConnect With a Mentor Commented:
Hi,

It should be as follows

Set objXL = WScript.CreateObject("Excel.Application")
....
objXL.ActiveWindow.DisplayGridlines = True
....
0
 
guswebbAuthor Commented:
Not tried that but did just stumble across another thread which works a treat...

http://www.experts-exchange.com/Web/Application_Providers/Q_20658116.html

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

From novice to tech pro — start learning today.