A
AlexT
A wierd one...
I have some code that defines print titles in a worksheet:
myWorksheet.PageSetup.PrintTitleRows = "$1:$6"
This works fine when running said code within an interactive session.
However I also have to run this macro while running Excel as a COM
object from another "master" process (say a whs script). In that case
the above code doesn't seem to work (no error but the print title is
simply flushed from the worksheet).
Out of despair I have also tried
myWorksheet.Parent.Names.Add Name:="Print_titles",
RefersToLocal:="MySheetName!$1:$6"
to no avail...
Any idea / suggestion would be most appreciated !
--alexT
I have some code that defines print titles in a worksheet:
myWorksheet.PageSetup.PrintTitleRows = "$1:$6"
This works fine when running said code within an interactive session.
However I also have to run this macro while running Excel as a COM
object from another "master" process (say a whs script). In that case
the above code doesn't seem to work (no error but the print title is
simply flushed from the worksheet).
Out of despair I have also tried
myWorksheet.Parent.Names.Add Name:="Print_titles",
RefersToLocal:="MySheetName!$1:$6"
to no avail...
Any idea / suggestion would be most appreciated !
--alexT