Thread: Problems setting HeadingFormat - and making it work
View Single Post
 
Old 04-16-2014, 10:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Tony,

I've both tracked down the 'Mid' problem and solved the heading rows issue!

The 'Mid' problem results from your code having a reference set to something called 'ScriptPW 1.0 Type Library', which I don't have on my system. I deleted that and the code seems to run fine without it. You might consider whether you need that reference - and each of the other non-standard references you have set.

As for the table heading row, solving that is as simple as deleting:
ScriptTable.Rows(1).HeadingFormat = True
from the 'InitiateScript' sub. You also don't need:
ScriptTable.Rows(RowCount).HeadingFormat = False
in the 'ProcessScriptBlock' sub.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote