Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting LeftHeader / CenterHeader
Hi,
as part of an ASP.NET-application, I am currently developing a script which is supposed to build a spreadsheet in Excel 2003 (under W2k or XP), fill it with data, format it and print it. Everything has already worked nicely, until a user started working with multiple filters in weh application. These filter-settings are supposed to be printed as part of the title, LeftHeader, to be precise. Now when the script runs, it comes up with an error saying something like "Cannot set the ..LeftHeader-Property of the PageSetup-Object". Somehow I then tried to swap the assignments of LeftHeader and CenterHeader, then it would set LeftHeader and crash with a similar error on CenterHeader. So somehow, it seems, these two are connected? I also tried to set LeftHeader in several steps and have now come to a state where it would set LeftHeader 3 times (until it has approx. 180 chars) and it would crash when trying to append 60 additional characters. Makes me wonder if there is something like a maximum size for these props? (Couldn't find any mention of that in the MSDN-Doc). Or why else would it fail here? (The LeftHeader has a leading CR, so it doesn't overlap with CenterHeader, it would go below the CenterHeader). Thanks Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter Multiple lines using .leftheader | Excel Discussion (Misc queries) | |||
Pagesetup. Is there no way to control the LeftMargin of the LeftHeader ? | Excel Programming | |||
Language portability problems when setting LeftHeader text from external app (=non-VBA) | Excel Programming | |||
VBA Code to Print a Variable as part of CenterHeader Problem | Excel Programming | |||
Excel generation and PageSetup.CenterHeader | Excel Programming |