Solved

Published Excel Workbooks

Posted on 2004-09-15
8
327 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
 

Author Comment

by:laevans
ID: 12106416
This is happening before the code is added
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SVG Star 4 35
How can I   ajax html table  rows? 20 62
Popup to change image and store url in database 2 30
Javascript to allow login/password authorization 4 29
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" …
Showing your events from Google Calendar in Google Maps Why? I travel all week and I thought it would be ideal if staff in office knew where I was based on my calendar. (OK real reason: my son wanted to see where I would be working, and I thoug…
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 embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…

911 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

21 Experts available now in Live!

Get 1:1 Help Now