integer codes for Excel FitToPagesWide ActiveX Needed

[jdebuhr]

Hello,

I am currently using LV6.0.2 and have been doing some Excel controlling in my program. I don't have the tookit so I am been doing most the Excel stuff using direct ActiveX commands.

I have gotten everything working but I am having trouble getting the FitToPagesWide to work before printing. I am not sure if there is an interger code, but if I use a I32 witha value of 1 it does not work.

This is also with Excel 97.

[Michael_Munroe]

I have Excel 2003, but 1 is the correct setting. Try to also set the Zoom to False. Here is a snippet from the help:

If the Zoom property is True, the FitToPagesWide property is ignored.

Example
This example causes Microsoft Excel to print Sheet1 exactly one page wide and tall.

With Worksheets("Sheet1").PageSetup
.Zoom = False
.FitToPagesTall = 1
.FitToPagesWide = 1
End With

Michael Munroe
www.abcdef.biz

[jdebuhr]

Thanks!!

At least I had the correct fit to page setting. I will try setting Zoom to false and see if that works.

[jdebuhr]

Thanks Again!!

I tried it this morning and it works perfectly. I knew I was close but I also knew i was missing something!