Class Module and Excel Properties Accessability?
I have been attempting to use a class module to programmatically format data
on an Excel spreadsheet. Using VB6 and referencing the Ecxel object library
most everything works well. I have used a test version that builds a sub
main to do the repetetive design testing.
I get to the point of setting some of the 'pagesetup' properties to add
title and footer info and to set page orientation and margins. These properties
work fine in the sub main executable test project but cannot be set from
within the class module....
The error: 'Unable to set the ...property of the PageSetup class'
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL