Excel-Like autofit

Question

I'm working on an application for making planning. For the moment I use the old system based on Excel + VBA macro. I've redone all but not the print system because Excel is very good for this. I've manage to paint a printpreview but the advantage with Excel is that you can draw all you want without take care of papersize when you want to print when you configure the page settings Excel will automatically adjust all so it fits good in the papersize and orientation you selected. Actually my printpreview is only for A4 but users can choose between A3 and A4 and maybe others in future. So i'd like to know if it is possible to make an Excel-Like autofit in function of the page settings. Thanks PS : sorry for my crap english languages are not my cup of tea :)

Administrator · Answer

Yes that what I use for moment but it's really long when I make several planning because COM and reflection for some call took so much times. I have a VB module that call Excel for drawing all my planning but it took much time too (50-85 seconds function of the number of planning to draw). My preview took 1-2 second to draw so that's why I think it's the best way but an autofit is necessary if I want something really good. Else maybe users can do with A4 preview to see if the planning is good and so use the Excel Drawing knowing they must wait...

Administrator · Answer

You could try to use Excel itself. There is a COM reference named Microsoft Excel lib (Excel 5.0 and 9.0 is wha I got). You can open an Excel document from your code with the help of this and use all its functionality in this way. Hope that helps Greetings Gilthanas