Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Published Excel Workbooks

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
laevans
Asked:
laevans
  • 4
  • 4
1 Solution
 
ZylochCommented:
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
 
laevansAuthor Commented:
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
 
ZylochCommented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
laevansAuthor Commented:
This is happening before the code is added
0
 
ZylochCommented:
0
 
laevansAuthor Commented:
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
 
ZylochCommented:
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
 
laevansAuthor Commented:
Thanks for everything!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now