07-28-2016 08:51 AM
Is it possible to insert a footer at the bottom of each sheet of an Excel workbook using the Report Generation Toolkit? Thanks.
Solved! Go to Solution.
07-28-2016 09:31 AM
There is a VI called Excel Set Page Numbering that writes to the footer. You could modify that if you want more than page numbers put into it.
07-28-2016 09:50 AM - edited 07-28-2016 09:50 AM
I was curious about Set Page Number, so I took a look. Turns out the code seems specific for Word 2007, and gets "down and dirty" with ActiveX. I've never used Excel footers, so have no idea if this particular function (from the Excel-Specific Palette, but seemingly internally calling Word functionality, which, given Microsoft, might be just fine) works or not, but I'd be reluctant to mess with it ...
Bob "Niwa Tori" Schor (that's "chicken" in Japanese)
07-28-2016 03:00 PM
I found what I was looking for - Set Report Footer Text.vi from the Report Layout pallet.
07-29-2016 09:27 AM
Oh Yeah, I went right for the Excel specific VIs and forgot about the Advanced Report pallete. Glad you found what you needed.