Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Published Excel Workbooks

Posted on 2004-09-15
8
Medium Priority
?
332 Views
Last Modified: 2010-08-05
I have created an upload utility with VBA. My users access the application and select an HTML file to upload. The HTML file that is uploaded starts off as an Excel Workbook, the user saves this workbook as an HTML file. Once the file is uploaded onto the Intranet a link is created and the company users are allowed to view this page. However, the problem resides within the print feature. After the file is uploaded there is no way to print the published workbook. The only thing that we are able to print is the screen shot of the workbook, therefore leaving off half of the page.

Behind the scenes of the application, I read the file in..check for certain lines of code to add my own line of code (to disable the right click and the CTRL-A and CTRL-C buttons).

Is there any setting, or any code that I can use to set the formatting features of these published workbooks?
0
Comment
Question by:laevans
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 36

Expert Comment

by:Zyloch
ID: 12089914
I'm a bit confused right now. The finished product will be in HTML, correct? The user begins with Excel, then they save it to HTML on their own time and then upload it? I'm afraid I don't quite get you, sorry, can you elaborate?
0
 

Author Comment

by:laevans
ID: 12101307
Yes, the user has an excel workbook that is to be saved as an HTML page. From here the user opens my application to upload the page to our Intranet.

While the page is being uploaded I add some code to the "HTML Page" ...this code will prevent the page from being copied and the right click will be disabled.

However, once the page is uploaded to the Intranet ....the output...the printed page is horrible. You only get a screen shot of the page and it is huge.

My question was...is there any code or anything in excel that will print the page accordingly?

I hope this clears it up for you.....Sorry it took so long to get back to you...was out of the office.
0
 
LVL 36

Expert Comment

by:Zyloch
ID: 12106339
Is it only after you add the right click code that the Excel webpage looks horrible? Does it look horrible even before you add the code? Just need to get it clear so we'll know how to proceed.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:laevans
ID: 12106416
This is happening before the code is added
0
 
LVL 36

Accepted Solution

by:
Zyloch earned 400 total points
ID: 12106554
0
 

Author Comment

by:laevans
ID: 12111787
This will work...however, I will have to place the Macro for each user and then explain how to use it. Is there anyway to incorporate this idea into my VBScript when I am uploading the file?

Thanks for everything!
0
 
LVL 36

Expert Comment

by:Zyloch
ID: 12121265
Hey, this does look you can do that. I'm not too familiar with VBScript or ASP or that sort of language, so unfortunately, I can't really help you there, but I recommend posting a pointer question possibly in ASP or ASP.NET to see if someone who has more knowledge than me can figure it out =)
0
 

Author Comment

by:laevans
ID: 12132888
Thanks for everything!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
In this tutorial viewers will learn how to style transparent/translucent elements using alpha transparency in CSS Start with a normal styled element, such as a div.: Define its "background-color" property as "rgba (255, 255, 255, .5): The numbers in…
In this tutorial viewers will learn how to style a corner ribbon overlay for an image using CSS Create a new class by typing ".Ribbon":  Define the class' "display:" as "inline-block": Define its "position:" as "relative": Define its "overflow:" as …

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question