o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Problem setting margins when creating an excel doc in ASP.NET -

Here's the deal: I have a web application that, when called, creates an Excel 2003 document on the web server, then redirects the user to the excel document. Everything's working fine except for one part: Setting up the margins on the page. This is the code I'm using:



Code:
Sheet.PageSetup.TopMargin = 0.5
Sheet.PageSetup.BottomMargin = 0.5
Sheet.PageSetup.LeftMargin = 0.25
Sheet.PageSetup.RightMargin = 0.25
If the above code is commented out, the application runs fine. If not, then I get an error: Unable to set the TopMargin property of the PageSetup class

Oddly enough, if I happened to ALSO be logged into the server, either through a remote desktop or directly logged into the box, I don't get the error.

Anyone run into this before?

 

Problem setting margins when creating an excel doc in ASP.NET -
Here's the deal: I have a web application that, when called, creates an Excel 2003 document on the web server, then redirects the user to the excel document. Everything's working fine except for one part: Setting up the margins on the page. This is the code I'm using: Code:

[2005] Bad printer margins... -
Hi all, I'm trying to print with VB.NET. When I try to draw say a rectangle based on the dimentions/position of the margins on the page (to get an outline), the margins are always off. Yes, I've set my margins propery in the code (they're all set at 50). Yes, I've tried manually set

Excel and locking Margins -
Hi I have a Q regarding Excel...here it goes I need to lock the margins of the workbook so that they can not be changed in the print preview or page setup.... Any Advice / Help would be great Thanks inadvance, Regards, Rocks

Creating Margins -
Hey, I am trying to build an advanced word similar to that Microsoft Word. The only problem i'm facing at the minute is creating a margin. Initially I would like to create a margins similar to Microsoft words, I would also like them to be adjustable. Does anyone know how to do

Data Report Margins/Print Problem -
I'm trying my post here since most of the views appear to be in the General VB forum........ I'm somewhat of a newbie with the MS Data Report designer. I'm having problems getting the margins correct. I need to have a label 1/4" from the top and left of my report. However, even

Convert... -
I found the page setup setting for the margins in WordPad and I need to convert them to decimal, I guess so I can programatically change the page margins. Here are the margin settings for 0.5 all around, Left, Right, Top, and Bottom. REG_BINARY=08070000 a0050000 08070000 a0050

Setting printer margins using API -
Does anybody know how to use the Windows API to set the margins of a page in a particular printer. Thanks.

will all of an 8.5 X 11 form print with printform -
Hello, I have created a form, setting the scalemode to inches and making the form 8.5 X 11. I have then added labels, shapes, etc., and want to be able to print the form to and 8.5 X 11 paper. Seems straightforward to print an 8.5 X 11 form to an 8.5 X 11 paper, but I think the

Data Report Margins/Printing Probs -
I'm somewhat of a newbie with the MS Data Report designer. I'm having problems getting the margins correct. I need to have a label 1/4" from the top and left of my report. However, even when setting my margins to 0, the report still prints with a 1/2" margin. The preview

Printer metrics -
If I substract the scaleheight and scalewidth from the printer height and width respectively, I come up with the horizontal and vertical margins where printing is not allowed. Now, I thought the printing area was centered in the middle of the printer area but it turns out the left and

Printing and margins problem -
Does anybody know how to find the margins which maximize the print area ? The default margin are set to 100 and I don't know how to get the printer limit. Anyhelp would be great

Setting Printer Margins -
The problem is probarly quite simple!! How do you set the margins, the place that the printer start to print from, in the printer module??? I write: Printer.Print "Something" and the text "Something" is at the top left corner!! How do I set the printer t

Margins in a textbox -
Can someone please tell me how to have margins in a textbox so that the type doesn't jam up against the top and sides? I've tried using a second, slightly larger textbox under the first to give the appearance of margins, but I ran into coding problems in resizing all the different for

MS Access - Page (report) Margins (VBA) -
Does anyone know how to set the report margins using code: When I open a report, I would like the margins to be 1 inch all arround and Landscape. Any ideas? Thanks

[2008] Printing Full Page - Margins Off at Top Left -
Hello, I am trying to print a full page of lines, labels, and variables to match a physical form that I have. When I go to print the form, everything is moved down and to the right. I have tried to set the margins to 0 and have also tried OrginsAtMargins but neither have corrected t

Margin -
I am trying to adjust the margin of a rech tex control I found the code below in MSDN. my understanding about the code below is that it changes the left and right margin and should apply it . do i need an additional code so that i can see the indention whe the margin changes t

Ms-Access report margins &%*& -
I have this app made using MS-Access 2000 and there is a repport that need to have a very specific margin... I CAN put it right so that it prints right on the user's computer. The thing is.. I don't have the same printer installed and each time I open it to work in it, the report margi

Data report margins are ignored. -
I have a VB data report with the left and top margins set at "0". When it prints, the left and top margins print at "1/2" inch from the edge. If I open Notepad and set the margins at "0" - it prints at "1/4"-left and "3/8"-top. How ca

Report formatting -
How do I keep reports formatted one way permanently? My reports are accessed throughout the network, and they become unformatted. No one actually changes that margins and the page orientation, but the setting change somehow. Has anyone else had this problem? Matt(+)

margins -
When designing a web form, how do you change the margins so it goes all the way to the top of the page? I can't figure it out. Thanks!

how to create progress bar in Excel -
I did some search before about this problem. They are using ProgressBar1, but when I put it in my Excel macro, it just doesn't recognize it. Is there some setting I should do before I use ProgressBar1 in the Excel sheet? Or how do I show the progress bar when I run the code in the

[2005] Programatically Get & Set the Page Margin from RDLC Report viewer -
Dear Friends I am facing a serious problem while Set & Get the Page Margin, Paper Size, Orientation etc to & from the RDLC - Report Viewer Page setup dialog. I want to do this in Programatically. Note : 1. Programatically I can able to get the default values of Pag

Printer Margins -
How do I discover the measures of the printer margins ? I try yo print a picture byt the .painpicture method to the total width and height of the printer and it prints even in the margins so the total pciture is not shown. So I want to print the total available area of the printe

[02/03] Install a printer -
hello again everyone! Let me give you the big picture.. I need to determine whether or not a person has included headers and footers, what the margins are etc. in his Excel spreadsheet. The problem is: Excel needs a printer to be installed before, I can access thqt type of info

RESOLVED: How to dynamically set report margins/layout in Access -
I have several reports in Access that should be set up landscape, on legal paper. However, sometimes the default setup will occur and cause the report to print out incorrectly. I would like to set the margins and layout of each report during run-time; however, I have yet to find he

Creating Excel -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data?? If you can help me with this you have done a great deed for the day.

API for setting the page margins -
I need to set the bottom margin thru my code, is there an API that I can use, or is there another way to do it? The Printer object does not provide this.

2 questions on printing -
Dear VB Wizards I have 2 questions regarding printing. Firstly, how can I set a forms Top and Left properties to set a forms focus, but so that it is not visible on the screen (so I can do a print screen style bitmap capture on it) and If I do this will it be invisible at all screen

RTF Code -
Does anyone know RTF codes? How can I change the margins through code? I am creating a file and sending RTF code, but i can't change the margins... strDefault = "{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}}" & _ "\viewkind4\

Printer physical margins without printing -
From other answers on here managed to get a function working to get physical margins of a printer if called from the printpage event of the PrintDocument with the PrintPageEventArgs as the argument. Is there a method of getting those margins without initiating printing or using the

Printer Margins -
How do you set printer margins? The bottom margin is not right and is cutting of my images when I print by a 1/2 inch. The top and left margins are ok. Just the bottom margin isn't. How do I set the bottom margin? I figured it out finally. I added a 1/2 inch to the paper size

How to set Top and Bottom margins of RichTextBox -
Hello. I have a RichTextBox and I want to print the text of it. So I set SelIndent and SelRightIndent to set left and right margins. What about top and bottom margins ? How to set them ? Here is what's print (the is no space before text on top and bottom of the page)

2 Instances of Excel Object using 2 VB Projects @ same time -
Hi, I am using VB 6.0 to automate some reports in excel. For every report there is a new VB project/VB executable. My Program does following; Creating a reference to Excel.Application object Opening an excel template Putting data in excel worksheets Saving excel

Resize page to suit resolution -
How do i keep the page the same size relative to the user resolution used. For example when i am creating my page in 1024x768 then the margins are quite far from the edge whereas if i switch to 800x600 then the margins reduce(page is much fatter) ....? I think it may be my css that

[2005] Report Size and Margins -
How do I set the papersize and margins in my report so the user will not set it anymore before printing?

Creating Excel Spreadsheets and Graphs -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data?? If you can help me with this you are goooood.

How do I programmatically set a control's margins -
Hello everybody, I understand the difference between margins and padding in that a margin controls the external distances between elements on a form while padding is used to control the internal distances of a control's content. Programmatically I am able to set a control's paddi

Setting part of text in excel cell to bold - (SOLVED) -
I'm creating an excel worksheet in VB and I have a line of text in a cell and only part of that text should be bold. Setting the font objects bold property to true or false affects the entire value property. I've tried putting the text in two separate cells and merging, but onl

Printer.Print Margins -
Hi Everyone, I am trying to create some printing code that prints in letter format. For example, having margins equal 1 inch on every side, top, bottom, left and right. I am not sure how to do this though. Any ideas? Also, I want to be able to have the text wrap around to the ne

print margins -
how can i set the top en left margins with the printer.print function? thanks in advance!