Printing HTML page with multiple sheets

[DKL01]

Hi,

We have a VB program which converts Excel file (with single as well as multiple sheets) to HTML. The conversion works good. But we are facing problems printing HTML sheets with multiple tabs. When we print the page it prints Sheet1 and then empty gray sheets. It doesn't print other sheets. I believe this is due to tabs (frames ). Is there any solution for this issue ?

Thanks

 

[crazyboybert]

i assume you have each tab in its own frame?

if this is the case it is the settings in your browser which control this. In IE there are settings to control the printing of frames in the print dialog box. I think you can choose to print them individually - all at once - or as they appear on the page.

I dont think you can control this option with script though you can tell the browser to print each frame seperately with script like this

window.framename.document.print()

however this wont work in IE4

hope this helps

rob