Solved

Published Excel Workbooks

Posted on 2004-09-15
8
328 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
  • 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

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

Accepted Solution

by:
Zyloch earned 100 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Introduction The Google Maps API offers various ways to draw dynamic and static maps.  Using a combination of PHP and JavaScript, you can draw active JavaScript maps that allow pan-and-zoom in the client browser window.  You can also draw "static" …
This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS (Continuation of the CSS Image Sprite tutorial) Create a parent ID for all the list items       - Specify position: absolute and display: block…
In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…

815 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now