Automating Heading Information

Forum|Forum|15 years ago
December 7, 2010
6 replies
4063 views

Any way to automate the heading fields? Some users keep forgetting to open the header/footer and changing the subject, user name, etc, as they don't see those fields when using the worksheet.

It would be cool to have push button that would open a dialog box that would open or update the Header, or perhaps a way to enter the header info in the visible part of the worksheet and have the header read that. That would save us from having people file calcualtions with incorrect identifying information.

Other

P

PhilipOakley

1-Visitor

It should be possible with a mix of a VBscript using the MathCAD API and a bit of using the Microsoft objects that the VB component can access. Basically, you get hold of the handle to the application then fire off the menu actions to fire up the header footer.

Have a look at the various other components, e.g. for access file directories etc.

Philip

M

MikeArmstrong

1-Visitor

Seems like a lot of hassle to be honest.

Why don't you create a template calculation, once opened the header and footer can be blank and you could have FILL HEADER & FOOTER OUT on the top of the first page. This would stop be forgetting.

Bit of a lazy solution