auto width in excel

[krispiekream]

can you try this..

[Sappster · Accepted solution]

Hi krispiekr…,

You need to not only specify the number of pages but you need to set the zoom property to false so that it will select the fit pages selection. Here is an example and I modified your program so you can use this.

Let me know if you have any other questions.

Message Edited by Sappster on 06-19-2008 03:15 PM

[krispiekream]

woww, that was easy.
how about if i want to automatically print and save then close all at once.



Message Edited by krispiekream on 06-19-2008 03:28 PM

[krispiekream]

i think everything is working now.
thank you so much for everyone help!

[DanNatCorning]

MikeS81, is there a way to fix the width of a single column in an Active Excel spreadsheet?  I have worked with the autofit and other properties with ALL columns but I can't figure out how to do it with just one.   Do I first have to set a range that includes only one, or is there a property that lets me define the index of the column I want to effect?

[George_P_Burdell]

DanNatCorning-

If you have the Report Generation Toolkit, this is very easy.  You can simply use the “Excel Set Cell Dimension.vi”.  This can be found from the Block Diagram » Functions Palette » Report Generation » Excel Specific » Excel Format » Excel Set Cell Dimension.vi.  If you are doing a lot with Excel manipulation, The Report Generation Toolkit will be your best friend.