Hello,
We have an Excel page in html on the Intranet.
Some want to print the page. And some of them get in trouble:
frames, from where you enter the page, what's selected etc.
For example, if the tabs are selected at the bottom you only get that frame.
For the less computer comfortable we want to present a button for each sheet
that prints the correct information.There is a mixture of browsers - of
course!

What's the easiest way to accomplish this? Linking to a non-frame, printer
friendly page and printing that?
Does JavaScript have anything easy like "Intercept printing and print this
frame"

Any ideas anyone?

Hi kkarre, can I ask you a, maybe, offtopic question? What do you mean by
"Excel page in html"? My boss asked me to develop a site with Excel page in
html, but I don't know how to do it. Do you save the Excel spreadsheet as
html (File-SaveAs), and put it in the website?

"kkarre" wrote in message
...
Hello,
We have an Excel page in html on the Intranet.
Some want to print the page. And some of them get in trouble:
frames, from where you enter the page, what's selected etc.
For example, if the tabs are selected at the bottom you only get that
frame.
For the less computer comfortable we want to present a button for each
sheet
that prints the correct information.There is a mixture of browsers - of
course!

What's the easiest way to accomplish this? Linking to a non-frame, printer
friendly page and printing that?
Does JavaScript have anything easy like "Intercept printing and print this
frame"

Any ideas anyone?

Yes.
/kk

"NONE" wrote:

Hi kkarre, can I ask you a, maybe, offtopic question? What do you mean by
"Excel page in html"? My boss asked me to develop a site with Excel page in
html, but I don't know how to do it. Do you save the Excel spreadsheet as
html (File-SaveAs), and put it in the website?

"kkarre" wrote in message
...
Hello,
We have an Excel page in html on the Intranet.
Some want to print the page. And some of them get in trouble:
frames, from where you enter the page, what's selected etc.
For example, if the tabs are selected at the bottom you only get that
frame.
For the less computer comfortable we want to present a button for each
sheet
that prints the correct information.There is a mixture of browsers - of
course!

What's the easiest way to accomplish this? Linking to a non-frame, printer
friendly page and printing that?
Does JavaScript have anything easy like "Intercept printing and print this
frame"

Any ideas anyone?

Hello KKarre,

Frankly, I am still not 100% clear about your design request. Would you
help me confirm the following points so that I can do a better support for
this case?

1. When you saved the Excel workbook as web page, did you choose the "Add
interactivity" option in the Save As dialog?
(I hope to know it because this option decides the appearance and some
frame structure of the generated html page)

2. You mentioned that "if the tabs are selected at the bottom you only get
that frame", I think this depends on how you print the page:
If you use the javascript window.print(); it will print the frame where
this javascript is located, and all its sub frames. So we can either put it
outside the whole workbook frame to print both the spreadsheet data and the
tab bar in the bottom, or put the javascript in a certain spreadsheet's
page (located in [WorkbookName]_files folder\sheet00n.htm) to print the
active spreadsheet data only.
If you use IE File menu - Print to print the page, we can print the whole
page directly, including the spreadsheet data and the tab bar.

3. I notice you expect the function run well in other browsers than IE. I
believe all the standard browsers support the javascript "window.print()".

4. What's the easiest way to accomplish this? Linking to a non-frame,
printer friendly page and printing that?
In the generated htm from the Excel workbook, there is a sub folder named
as [WorkbookName]_files. Each worksheet in the original workbook are stored
as sheet00n.htm in this folder. And these htm's has no frame. Therefore, I
think we can write the javascript as:
<script
function print_url(url)
{
location=url;
print();
}
</script
<a
href="javascript:print_url('http://¡*/[WorkbookName]_files/sheet001.htm')"P
rint sheet 1</a

Am I understanding this case correctly? Feel free to correct me, thanks.

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello KKarre,

Would you mind letting me know if my understanding of the issue is correct
in my last reply? Are the suggestions based on my hypothesis helpful to
you? Please help to confirm the points so that I can share more experience
and ideas with you. I am looking forward to you reply.

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
.

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================