Exporting to Excel - Progress Bar Problem

foolosofo
foolosofo Member Posts: 73
edited 2007-01-17 in NAV/Navision Classic Client
Hello!!

I'm using Excel Buffer to export some records to Excel. I'm entering the cells and finally, I execute these instructions:
  ExcelBuf.CreateBook;
  ExcelBuf.CreateSheet(DELCHR(FORMAT(TODAY),'=','/'),' ','','');
  ExcelBuf.GiveUserControl;

However, when I run the report, the progress bar shows 100% when it's still creating Excel worksheet.

What's the problem? I want that the progress bar shows the correct percentage of created worksheet.

Thank you.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    see this example to see how it's done
    http://www.mibuso.com/dlinfo.asp?FileID=596
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • foolosofo
    foolosofo Member Posts: 73
    Thank you for your answer. However, I've tried this code but the problem was not fixed.

    This code creates a pre-window with a progress bar analizyng the data. At the moment it's correct. But, then, when Creating Excel worksheet window appears, it fills the progress bar to 100% while it's creating the worksheet (and it may be for 5 or more minutes depending on the process).

    So, I'm interested in get a real progress bar in this last Creating Excel Worksheet Dialog.

    Thank you!

Categories