Solved

ASP to Excel show gridlines

Posted on 2009-04-14
2
325 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now