Solved

Published Excel Workbooks

Posted on 2004-09-15
8
326 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
This is happening before the code is added
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 36

Accepted Solution

by:
Zyloch earned 100 total points
Comment Utility
0
 

Author Comment

by:laevans
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks for everything!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Do you want to insert HTML5 video into your site? This is the tutorial how to do so. What are the main advantages of HTML5 video? 1) Have good compression, good image quality, and low decode processor use. 2) It is royalty-free 3) It is easi…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
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 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…

772 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

12 Experts available now in Live!

Get 1:1 Help Now