Solved

ASP to Excel show gridlines

Posted on 2009-04-14
2
335 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:guswebb
2 Comments
 
LVL 17

Accepted Solution

by:
NicksonKoh earned 500 total points
ID: 24143981
Hi,

It should be as follows

Set objXL = WScript.CreateObject("Excel.Application")
....
objXL.ActiveWindow.DisplayGridlines = True
....
0
 
LVL 9

Author Comment

by:guswebb
ID: 24144019
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question