another question on Excel and VB

[mn12]

I create reports by Excel and use them with vb application.
when the application is running,the reports are displayed by printpreview method.
the problem is: before the report is displayed,
I see for a second the regular workbook of excel(with the gray and white squares).

how can I solve the problem??

 

[RobBroekhuis]

set

AppExcel.screenupdating=false
at the beginning of your code (after you create the Excel application object), then turn it to true right before you execute the print preview command.
Rob

 

[computergeek]

Hi,

Is your XL sheet contain a select or database procedure that requires parameters? If yes, how do you set the parameters and retreive the Excel report. (A code snippet would be great...)

Thanks,

Computergeek