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'

Ideas?