Fix the width of excel cell

Silva
Silva Member Posts: 281
edited 2009-08-20 in NAV/Navision Classic Client
Hi,

Is there a way to fix the width of the cell in excel?

Scenario:

1. I create a report that get the template in Excel file.

2. Use the template to populate the data base on the excel template.

3. But when send all the data to excel it, ruined the template because the cell is expanding, so I want to make it a fix width even i throw a data to the template.

Im using NAV 5 sp1 and I use the report 7113 Export Analysis Rep. to Excel as a reference and uses a Excel buffer table. Any advise will help, Hoping for your reply



Thanks

Answers

  • garak
    garak Member Posts: 3,263
    Check the property "With" on the variable XLRange. To disable the AutoFit, you must deactivate the part in the excel Buffer (maybe throug a variable that u set before) where the "AutoFit" is set.

    To understand better how the Excel automations work, open the VBA onlinehelp (like VBAXL10.CHM). It's on your Program files folder or on your product CD if you have it not installed. The help looks like this for Access download/file.php?id=296&mode=view

    Regards
    Do you make it right, it works too!

Categories