Printing in excel

[ramanakala]

Hi friends,

Is it true that printing in Excel is slower when compared to printing simple text files? I was developing a project in which I am developing reports in Excela and suddenly the requirement changed to text reports saying that the printing is slow in Excel. But I don't understand how to do it as there are many formula caluclations ( mainly additions ). So, I want to know how to achieve this. Plz clarify my doubt and if u've any example of generating text reports with caluclations, Plz help me out. Thank You

[khalik_ash]

AFAIK i think if ur job with excell is done export the data to text file and then print... if not requied delete the file...

[Static]

are you exporting the data to excel for formatting/printing?

Yes a simple text file prints very fast...because there is no real formatting...or even fonts to deal with


but if its simple text your printing...

print right from your VB app

Printer.print "Hello there!"
Printer.endoc <-been a while...someone correct me if wrong