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

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
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 9999
End With

'Show the file
xApp.Visible = True


Previously it was working fine.
but suddenly the error is poping up
is it any thing to do with printer access?

please guide me on this

thanks in advance

 

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

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

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

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:

[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

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

Run-time error '1004' Unable to set the autoFit property of the Range class -
Error = "Run-time error '1004' Unable to set the autoFit property of the Range class" I am using the below method to create an excel spreadsheet however, keep getting the above error at the line ws.Range("A1:A10").AutoFit = True and alturnatively the commen

ToolTip for ToolBar buttoms -
Hi I'm having trouble getting my tool tips to show for my tool bar buttoms. I've set them in the properties, but they don't show. The tooltip for the toolbar does show. I tried seeting it to false to see if it would bring up the tool tips for the buttons, but it didn't help. I've

[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

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

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

so far no one has been able to help -
i'm using VB 6.0 to open word and create a new document. in the document i need to center some of the text but VB doesn't recognize the word constant wdAlignParagraphCenter i'm using the following code and it isn't working: Set FormsList = CreateObject("word.application"

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

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

[ RESOLVED ] Combo Box... -
I have a COMBO BOX with 5 items... I need a code for seeting its default text to first value in combobox.. Urgent...

Anmation Help,Please!! -
I, being new at visual basic, am seeting out to be a game programmer. and though i have barely scratched the potential of this wonderful program, i need some help! I need a no frills explanation of how to animate sprites very simply. Please, will some helpful person explain??

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

Error in implementing IXMLDOMNode Interface -
I am trying to implement IXMLDOMNode Interface by using Implements IXMLDOMNode. That interface has one of its property definitions as given below, which differs in data type. As in Let Property definition it has String data type where in Get Property it has Variant. Private P

Data Control Error --NOT Rreolved-- -
I received an error when I clicked the dropdown arrow next to the RecordSource property: (Yes, the error is blank) The DatabaseName property is pointed to a valid database, and the Connect property is set to Access... I tried regsvr32 msvbvm60.dll, which didn't work... Do

For all the Experts out there -
I am using VBa for Excel, and I am trying to print a selection. I am unsure how to print just the selection. Here is what i have: Sub p() Dim rowRng As Range, pntRng As Range With ActiveSheet .PageSetup.Orientation = xlLandscape Set rowRng = .Range("102:146&quo

Handling errors in Property Set -
I've run across, several times, statements to the effect that defining a property lets you check what users enter before you accept it. The problem I'm having right now is, how do you handle the error when it occurs? Property MyName as String() Set(ByVal value As String)

VB.NET Excel Pagesetup Problem -
I have some code that creates an Excel report that works fine when I am logged into the server. This program runs as a scheduled job in Autosys on Windows Server 2003, so when my report runs late at night, if I'm not logged in to the server it throws the following errors : The first

Run extensive code while screen remains "calm" -
Hello All, I am now in the process of trying to "clean-up" my program . I am trying to make it look more professional and squared away now that I got everything working (largely with your help!) I do have a question regarding the following code..... How can I have this

myCell.Value = 2, but myCell must show "xlLandScape" -
Basically, I want to reference the PageSetup.Orientation value to be 2 (which sets the xlLandscape property), but to the end-user, it must appear to show "xlLandscape" on the excel sheet. Can anyone tell me how to 'mask' it?

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

[2005] Getting and Setting a Property at the same time -
I am wondering if any one knows what would happen, if I get a property at the same time it is being set. This application that I am working on we get this random error that happens anywhere from 2 - 48 hours of it running. The only error we get says that something crash in MsCorWks.d

free ocx to change seeting date -
http://www.vbforums.com/showthread.p...hreadid=253347

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

DataGrid: seeting font to a particualr column -
Hello, I am using a datagrid control to display data. I want to use different fonts for various columns that are displayed in the grid. For Example i want the 2nd column to set to : Arial font & 3rd column to be set to :Garamond font. Can this be done. & if so pls let

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.

spreadsheet won't fit in a single page when printed -
I have a spreadsheet that I populated from an access table (file). when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record. I have used:

how to use arrays in VB property -
Hi All, i'm trying to read one text file , if the strings in text file matches to any of the type which is written in regular expression (which is in XML). i want to store all those in an array to print it later. Here is the code: ObjInvoice.Amount() = regEx.Replace(s

Keep getting this error after adding a ListView to my project.. -
Keep getting an error since I added a ListView to my project. When the project opens, the ListView ends up becoming a PictureBox Here is the info from the log file: Line 25: Class MSComctlLib.ListView of control ListView1 was not a loaded control class. Line 31: The property name

Excel Run-Time Error 1004 -
Hi, On occasions I'm getting the following error when trying to set the LeftHeader property using the PageSetup class: - Code: Run-time error '1004': Unable to set the LeftHeader property of the PageSetup class Here is the code: - VB Code: Sub PrintSetup(lngS

read/write registry -
Hello. After some search here in vbforum, I decided to use the file "Microsoft Visual Studio\VB98\Template\Code\Registry Access.bas" to read and write values from/to registry. But I just can't find any simple example for it. So, I want t read a value from "HKEY_CURR

ChartTitle Class, I hate excel -
I'm just trying to set the chart title from within my VB app, but it tells me: Run-time error '1004': Unable to get the Characters property of the ChartTitle class. I also tried the Caption property and the Text property but both give the same error. Anyone know what the pr

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,,

Here's code to print, printpreview, & pagesetup for a datagrid -
Here is the code for all of those that would like to enable printPreview, PageSetup, and Print on a datagrid: Imports System.Drawing.Printing Private PrintPageSettings As New PageSettings() 'For PrintPreview Private Sub PrintPreview_Click(B

VB Excel Userform - print in Landscape -
Hello I am having trouble printing my user form in landscape view. here is my code... Private Sub cmdPrint_Click() With InputForm .PageSetup.Orientation = xlLandscape .PrintForm End With End Sub "Method or Data member not found" this is the error message i am ge

Runtime Error 380 when setting icon property -
When trying to set the icon property of a form to a .ico file I receive this error: Runtime Error 380 Invalid Property. I cannot set it at runtime either with the frmMyform.Icon = LoadPicture("c:\myprogram\My.ico") format. I get the same error. I thought it might be