Stack Overflow
Stack Overflow

Questions tagged [page-setup]

43 questions
1
vote
2 answers

can't set PageSetup.Orientation = xlLandscape from MS Project

Using VBA in MS Project 2003 I create an Excel sheet and write data to it. After that I want to change SetPrintArea and Orientation of the sheet I created so I wrote with xlsheet '// Defined being an Excel.Worksheet For i…
user191093
  • 43
  • 1
  • 3
  • 6
0
votes
1 answer

Control page setup options in Delphi without showing Page Setup dialog

In my Delphi application, I can use the following code to show the Page Setup dialog to my users before printing. //WebHTML is a TWebBrowser with a Document loaded. WebHTML.ExecWB(OLECMDID_PRINT, OLECMDEXECOPT_PROMPTUSER); Is it possible to change…
Kyle Williamson
  • 2,251
  • 6
  • 43
  • 75
0
votes
1 answer

full-page div flowing past bottom and right of page

I'm trying to set up this page so that some of the individual divs are scrollable while the page itself doesn't have overflow. I swear, I've done this a hundred times before, but I've always just managed to get the page functional, using a lot of…
puncushion
  • 15
  • 4
0
votes
1 answer

Apply Page Setup Columns settings to selected text only not entire document

I'm trying to create a macro in microsoft word that can apply different number of page columns in different parts of the same page, guided by selected text. When I do it manually, its possible because I can choose the Apply to: Selected text option,…
pmugzz
  • 1
  • 1
0
votes
1 answer

webbrowser control page setup options from code

I have a .net Forms Application with webbrowser control. I have a html file loaded in the control. I want to set Margins, Headers and Footers and orientation from the code itself for printing that…
Sr7
  • 341
  • 1
  • 10
  • 19
0
votes
0 answers

Fill set columns to pdf

I am exporting a .xlsm sheet to PDF using Visual Basic (VBA). I only want to export the columns A:Z. I have tried this: Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws.PageSetup .PrintArea = "$A:$Z" …
Storm1
  • 199
  • 1
  • 1
  • 10
0
votes
2 answers

Excel VBA Page-Setup - Page fit to width looses it's value after adding HPage-Breaks

I am trying to set-up an Excel sheet with about 3000 rows, to print nicely to a PDF file. I am trying to set-up the page to fit 1 page width, and I want to modify the Horizontal Page breaks according to row numbers stored in an array…
Shai Rado
  • 33,032
  • 6
  • 29
  • 51
0
votes
1 answer

How to make the "PageSetting" dialogbox of Notepad.exe in .NET app?

I Want make a PageSetting dialogbox by .NET like this in Notepad.exe: I write the code use System.Windows.Forms.PageSetupDialog, it just look like this: I tried the PAGESETUPDLG.lpPageSetupTemplateName with Win32 API, it works. But the UI is too…
zmrbak
  • 1
  • 2
0
votes
0 answers

Page size option in IE11's Page Setup only shows Oficio 216x340mm, Oficio 8.5x13 and Youkei 3 (98 x 148mm) in Windows 7

We have this intermittent printing issues with network printer where we triggered Page Setup in IE11 in the Win7 PC, it does not give us the usual Page Size like A4, A5, A6. Instead we are only allowed to choose from Oficio and Youkei. Restarting…
C.H.
  • 11
  • 4
0
votes
1 answer

How to have the table header on the top of each page if horizontally dynamic

My table has the categories all in column A, starting with "A3". The following columns have the data and the number of columns may vary each time the report is run. Row 1 has the chart title and row 2 has a legend ("A1:G2"). "H1" to end is blank.…
RebaS
  • 47
  • 8
0
votes
0 answers

Store and retrieve Excel PageSetup

I'm programming an Excel VBA macro to automate a print task. What I want to do is to store the PageSetup object of a workbook, do my things, and then restore the initial parameters. I tried this : Sub test() Dim TempPageSetup As PageSetup Set…
Bedasy
  • 13
  • 4
0
votes
2 answers

Change Orientation to xlLandscape without first print preview

I have code that includes changing some of the .PageSetup variables. I'm having issues where I use this code Sub Test() Dim ws as Worksheet Set ws = ActiveSheet With ws.PageSetup .Orientation = xlLandscape End…
Jason Brady
  • 1,560
  • 1
  • 17
  • 40
0
votes
0 answers

Change default slide-size on PowerPoint 2010

I use PowerPoint 2010 and need to create automatically PowerPoint (with excel VBA) with the slide size 16:9, so I would like to set this value as the default one (instead of 4:3). Could someone help me ? Or does someone maybe know how to choose this…
Charlotte Wiatrowski
  • 25
  • 1
  • 1
  • 7
0
votes
1 answer

Print Preview in ReportViewer display blank screen

Below is the code for the new page setting: Dim newPageSettings As New PageSettings newPageSettings.Margins = New Margins(20, 20, 20, 20) newPageSettings.Landscape = True Dim paperSize As PaperSize = New PaperSize() paperSize.RawKind =…
stillLearning
  • 84
  • 2
  • 12
0
votes
0 answers

Requested PaperSize is not available on the currently selected printer

I would like to copy some excel data in to a word document using VBA The excel data is build for print area A3. After creating a word document, I am trying to set up paper size for new word document to A3. It is giving me a run time error Run time…
Palee
  • 17
  • 1
  • 4
1
2
3