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

Excel PageSetup Zoom category -

Hi,

I've got some code that has run fine on a web server for years, I moved it to a new server this week and now get the error message below. As far as I can tell everything is identical, windows 2003 server IIS6, same version of excel.

Can anyone help? I've tried installing a printer driver as recommended in a couple of articles but it didnt make any differece.

Thanks

Unable to set the Zoom property of the PageSetup class
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Unable to set the Zoom property of the PageSetup class

Source Error:

Line 767:
Line 768: For Each tab As Excel.Worksheet In WB.Worksheets
Line 769: tab.PageSetup.Zoom = False
Line 770: tab.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape
Line 771: tab.PageSetup.FitToPagesWide = 1

 

Excel PageSetup Zoom category -
Hi, I've got some code that has run fine on a web server for years, I moved it to a new server this week and now get the error message below. As far as I can tell everything is identical, windows 2003 server IIS6, same version of excel. Can anyone help? I've tried installing a pr

error while seeting pagesetup property in vb 6.0 -
hi, i am getting the following error while setting page property for excel here i am giving the code which i am using in the application Error: 1004- Unable to set Zoom property of the PageSetup class Code: 'Setting Fit to Page With xBook.Worksheets(1).PageSetup .Zo

How to import PageSetup attributes from Excel -
Esteemed Forum Participants and Lurkers: I can open and manipulate data in an Excel Spreadsheet (Excel 97-SR2), but is there any way to read/import the PageSetup attributes? I especially need to see the "PageSetup.CenterHeader" value. Thank you for any and all comments

[Excel 2003] Print page setup appears to take 30 secs or more -
Hi, I have done a record macro, tweaked it to use objects but I have noticed that the excel app takes ages setting each option on the sheet. Is there a way of speeding this up? Code: sht.PageSetup.Orientation = xlLandscape sht.PageSetup.Ce

zoom without aspect ratio -
i originally posted this in VBA forum, but seeing many posts here related to excel, i'll try here as well is it possible to zoom an excel sheet without preserving the aspect ratio...for example: ActiveWindow.Zoom = 200' preserves aspect ratio... IS there ANY way to to accomplis

[VB2005] Worksheet Zoom -
Can i change the zoom property of a sheet from vb2005 basic? I have this code but its ignored when it run.. Code: Private Sub cmdSaveNewCustomer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSaveNewCustomer.Click Dim oWB As Excel.W

Excel page setup -
I have this code Code: For Each tab As Excel.Worksheet In WB.Worksheets tab.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape tab.PageSetup. tab.PageSetup.FitToPagesWide = 1 tab.PageSetup.CenterFooter = "STANDA

[2005] Zoom In, Zoom Out Facility in Excel using VB .NET -
Hi Friends, I am putting data in excel sheet and giving its graphical representation. I want to put an icons and I want a facility 'Zoom In' and 'Zoom Out' with the cursor (+)and (-), the way its available in JPEG image viewer (Windows Picture and Fax Viewer) or in any 'Print

Pdf to Rtf -
Hi all, i am in need to convert the pdf file to rtf file.. i did it using an third party component, now i have to set page orientation, and page size to the converted RTF,. Converted RTFo is an string only, Already i did these all to Excel, Code: If Orientation = 1 Then

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:

Table in N Sub-Category -
Im designing an ITEM Database with unlimited sub-category. The data hierarchy will give me something like this: Item Master '- Sub Category 1 '- Sub Category 1.1 '- Sub Category 1.1.1 '- Sub Category 1.1.1.N '- Sub Category 2

How do I format PageSetup in Excel from Access using VBA -
Does anyone have any suggestions about programming PageSetup in Excel from within Access using VBA? For example, the following variations of code do not work: .PaperSize = xlPaperLegal .xlPaperSize.xlPaperLegal .PaperSize.PaperLegal Thanks

internet explorer pagesetup -
hi all! I'm facing the following problem: I need to change the page margin of an internet explorer document out of an excel application (for printing) as far as I know there is the possibility of changing the PageSetup registry key, but in excel it is not possible to use a sta

[2005] Excel Page Setup Code -
I have the following Excel related code in a Sub Code: Dim objExcel As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application) Dim bkWorkBook As Excel.Workbook = DirectCast(objExcel.Workbooks.Add(), Excel.Workbook) Dim shWorkSheet As Excel.W

Zoom Function In VBA -
I am using a user form in excel. Is there a way that I can create 2 buttons for zooming? One with a "+" to zoom in and one with a "-" to zoom out. If so, how would I write the code for that?

Pagesetup is slower than a snail! How can I speed it up -
I create diagrams via VBA in Excel. Everything works neat and at a reasonable speed except all of the pagesetup functions. Those all need a few seconds each! In total this takes up 20 - 30 secs for EACH diagram. Is there a way to either speed things up or define that stuff once and for

I need a Zoom In, Zoom Out Pic -
All I need is a zoom in pic and a zoom out pic for my toolbar. Does anyone have any or would like to draw one up. I am horrible at making pics. The ones that I found on my pc look horrific. Thank You

Excel controls -
Hi I am using Labels and Combo boxes in Excel 2003 application. I have designed the excel sheet setting the Zoom magnification to 94%. But when I reduce the Zoom magnification to 78% the font of the labels and dropdown boxes is changing. I have set the font as bold for labels and dr

Excel Category property -
Can anyone tell me how to return the Properties of an Excel spreadsheet, I need to get the 'Category' (from Excel menu - File, Properties, Summary). Thanks

what is zoom doing -
When an app, like excel for example, allows you to zoom in/out, what is it actually changing - resolution, dpi ??

zoom in and zoom out -
how to write the code to zoom in or zoom out the picture? can anybody provide the code on zoom in or out function?

Zoom zoom -

Print Menu Selection -
[highlight=VB]BELOW IS WHAT I HAVE TO START WITH BUT I WANT TO STOP AND SELECT FROM 7 TO 8 PRINT AREAS I DID HAVE A REPLY BEFORE BUT DIDN'T UNDERSTAND IT SO I THAUGHT I WOULD START OVER. ALL MY PRINT RANGES ARE NAMED PRT_SUN PRT_MON AND SO ON SOME AR

Program error in XP -
I have a program that I wrote in VB6 with an access database and reports that are run to excel. The reports to excel work fine from most computers, but from others it gives an Error 1004....Unable to set the PrintTitleRows property of the PageSetup class, or Error 1004....Unalbe to se

How many columns do I need in the database -
Dear Friends, I have to create a database & project but I don't know how to. Because I have a product list of 3 categories. 1st category has nearly 1500 items. 2nd category has 15 items and 3rd category has 25 items. The below is the example: 1st Category : TMF-001 to TMF-150

page setup=landscape in excel -
hi, i want to make an excel file from visual basic wich is landscape my code is this oSheet.PageSetup.Orientation = Excel.Constants.xlLandscape and it has the error xllandscape is not a member of excel.constants

TreeView.SelectedItem.Next -
Im having a problem, here's an example of the treeview: Main Category ...Category 1 ......File 1 ......File 2 ......Sub Category 1 ..........Sub File 1 ...Category 2 ......File 3 ......File 4 When i delete Category 1, i need to go through every entry between that catego

CommandButton Text: Zoom In/Zoom Out on Mouse Events -
I have a CommandButton and I've tried the obvious ways to make the Font Zoom Up to a certain level on the MouseOver Event and Zoom Out when the mouse is not on the CommandButton but none have worked. There is probably something really simple I'm not doing so can someone please help

if statement with monthcalendar -
hello, I'm new to VB and so do not know all the correct syntax required, thus I need your help. Globally, I'm trying to make an excel workbook to handle my expenses. I have a button to add an expense which brings up a windows form where you can enter the DATE (through a MonthCalend

Excel pagesetup slow on fast machine, fast on slow one - why -
I have some code that produces diagram in Excel adds them as new forms and in the end sets up the page for printing. I need to run this on two machines. Both NT4 SP6, Excel2000, Laser Jet 2100TN. While on one machine(actually the one with the slower CPU and less RAM) the code execut

Export datagridview to Excel.. -
Hi all, The data exporting correctly.. But when save the record, it asking Do you want to replace the existing Sheet? If i gave YES no problem, the sheet is overwrited.. If i gave no..An error throwing.... Exception from HRESULT: 0x800A03EC I dont know how to proceed,,

How to shrink print output -
Hi everybody, I tried to shrink the printer output by assigning the Printer.Zoom property of the printer object to 80 as follows : Printer.Zoom = 80 , before issuing Printer.Print commands, but this is not working. MSDN help says that all Printers don't support zoom, but I bel

VB6 Formatting Pages in Excel from VB -
I've written a program that takes info from a database, formats it and enters some calculations and exports the information to a spreadsheet. This appears to work ok but I am trying to set up the formatting of the final printout for landscape and fit the column widths on one page.

Flexgrid zoom -
I have a flexgrid with scrollbars, is there anyway to zoom out (or optionally zoom in/zoom back in to "normal") so that more of the flexgrid can be shown, just smaller everything... Thanks

DirectDraw (need to Zoom, Replace Color, etc) -
I have downloaded the DX8 Partial SDK for VB The first tutorial I could probaly use for the zoom (although all it does is resize the picture to the form's size) I need to do three things (ordered by priority) 1) Be able to replace a color instantly (like change all green pixel

a question zoom out a picture -
I try to zoom out a picture in a picturebox using stretchblt API or paintpicture method , it 's normal working when the picture's width/height under about 6000 pixels, but if over that size, the picturebox will be filled in backcolour, any image date lost. for example: i try to zo

Click and drag zooming -
Ok, I have no idea where to start. I have a picture box that loads an image from a sql database. Currently I am using a zoom in and zoom out control to allow users to zoom. What I would really like is for the user to be able to click and drag a transparent rectangle over the area

Picturebox Zooming and Scrolling -
What's up? I was wondering if there was any code out there that allows me to zoom into a picture in a picturebox, and then adjust the vertical or horizontal scrollbars so that if I click on the "zoom in" or "zoom out" button, it will zoom to the middle of the ima

Zoom in an out! -
Could someone please help me by telling me how i could zoom. Here's my situation: i have got an image in a picture box and i want to be able to zoom in and out through my program.

please help with my SQL statement -
Hi all.. please help me with my sql problem. I have 2 tables, Category and Sales. In the Category table, I have 3 items: CAT A CAT B CAT C and in the Sales table, I have 4 Items: Category: CAT A CAT A CAT B CAT B Quantity 10 --> for C