Results for the access Private Sub cmdPrint Click() With InputForm .PageSetupVB 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 [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 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 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 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 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 [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 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: 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 Code for printing out listbox to default printer - - Greetings, Hope all is well. I have a listbox called lstCampers. I also have a button called cmdPrint. I need the code for the exact contents in the listbox to be printed, when cmdPrint button is clicked. Also, I need to default the printout to landscape. What is some quic 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" 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 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 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 How to access a private function - i ahave a .dob file which has all private functions private sub validate() private sub cbo_change() etc I have to write a public sub click() then have to call a private sub validate() in this click() how can I do that ... Thanks in advance. Printing a DataGrid nicely and Multi page - Hi, I would like to know how can i 1. print a datagrid nicely in proper format (like document) 2. print using crystal reports 3. print multi-pages these are my codes so far, thanks, help appreciated! - Imports System.Drawing.Printing Private PrintPageSettings As New 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: Crystal Problem Help Please !!!! - Hi all, i'm using crystal to draw reports from an Access Database. I get my report parameters from a VB inputform and pass this through to my Crystal Report via the Crystal Report Object. The entire report works fine except that the Access Database has a database password on it an |