auto width in excel

[krispiekream]

hello,
i have created this excel file.
i was wondering if someone can how me how to autosize the width.
i want it to autosize the width as i open up microsoft excel.
can someone show me how to do that.
thanks






Message Edited by krispiekream on 06-16-2008 07:55 PM

[CharlyStardust]

Hi krispiekream,

You can use the autofit method or you can write a macro in excel.

Have a look at this thread http://forums.ni.com/ni/board/message?board.id=170&message.id=24472&query.id=67391#M24472 There is an example which includes a "columns" property and a "autofit" method.

Charly 

[krispiekream]

great,
thanks for your help.
that worked.
but one last question,
how do i make it fit into one page?
so its easier to print.

[MikeS81]

Hi krispiekr…,
if you want a fix width, then you can set the column width "manually" (column by column with ActiveX functions).

Mike

[krispiekream]

i got it to autofit and it worked fine.
right now, i either want to close it save it.
i am having a hard time saving it with autosize width already.
everytime it popped "save yes", "no","cancle".
when i put save. and oonce i open it up again, the file did not autosize the width for me because it save has delimiter or something.



Message Edited by krispiekream on 06-17-2008 11:58 AM

[krispiekream]

i want it to automatically print using this





Message Edited by krispiekream on 06-17-2008 12:31 PM

[krispiekream]

i did this.
yet it still print out 2 pages.







Message Edited by krispiekream on 06-17-2008 01:11 PM

[MikeS81]

Hi krispiekr…,
could it be that your event execute two times?
Mike

[krispiekream]

----------------------------------------------------------
could it be that your event execute two times?
Mike


it could have, but i have tried it so many other ways.
i think i will give up on this.

[MikeS81]

Hi krispiekr…,
maybe it helps if you change the mechanical action of your button to "latch when released". If it don´t helps, can you upload your code?

Mike