Excel Page Numbering with ActiveX

[Nick_S]

I've brought a data file into Excel from Labview using the ActiveX properties and methods.  I've formatted everything the way I like it to be displayed in the Excel file.  I can't find the Excel  property(s) that will display the page numbers, for instance in a footer or at the bottom of each page.  I'd like to use a footer with the "Sheet x of xx" format.  Anyone done this before?

Nick Salemi

Teledyne Energy Systems

nick.salemi@teledynees.com

410-891-2257

[Darren]

The LabVIEW Report Generation Toolkit for Microsoft Office has a VI that does this.  Specifically, it gets a reference to the ActiveSheet, then gets a reference to the PageSetup for that active sheet, then sets either the "LeftFooter", "CenterFooter", or "RightFooter" property of the PageSetup to a value of "Page &P of &N".

Let me know if you have any questions about the Report Generation Toolkit...we spent a lot of time discovering the answers to questions like this one and making VIs out of them.  🙂

-D

[Joe_H]

I would also suggest creating a macro of the operation and trying to reproduce it in labview using properties and methods.

[Nick_S]

Thanks Darren,

I had a feeling it was simple.  Using a Worksheet property node tied to a Page setup property node with Right Footer displayed, I connected the code you suggested (Page &P of &N) from a text box to the Right Footer.  Works like a charm thru hundreds of pages!

Nick S

[Nick_S]

Joe,

Heres some code.  Yell if the zip file does't make it.  Place the two files on the C:\ directory.

[Joe_H]

Thanks for the VI'S I will add these to my collection.

[Nick_S]

Joe,

You seem to know your way around the Dev. Zone discussion format.

How did my question get removed from the main board? I thought I'd have to do it myself.

Instead I found that it is only listed in My Subscriptions.  What did I miss?  What should I normally do to it?  Delete it or just leave it alone.

Thanks

[Joe_H]

It did not get removed it just got pushed way down the list. When you ask a question it gets put on page 1 of the main board. and as more people ask questions it gets pushed down the list (very quickly) then when some replies to your question it gets put back at the top of the list. Lather rinse repeat. you can verfiy this if you want. Down at the bottom of the main page is an indicator to tell you what page of the main LV page you are on. A question just keeps getting pushed down the pages.

You cannot delete a Post. Only the board administrator can do that.

Hope this helps.

[ShawnC]

LabVIEW Report Generation Toolkit for Microsoft Office

This is a dead link.