Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ASP to Excel show gridlines

Posted on 2009-04-14
2
Medium Priority
?
350 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 1500 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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 have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
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/…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

916 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