Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Page (not a sheet) using VBA.
Hi, Here's a tricky one...
I want to be able to select a specific page in a workbook, and copy it to another workbook. For example: if sheet 1 prints out over 3 pages, I need the vba to select the second page of this. I can use VBA to select manually added pagebreaks, by referring to the vpagebreaks and hpagebreaks collections of the sheet, but this does NOT reference automatically added page breaks. This is probably because auto-pagebreaks have to be recalculated (re-paginated) every time you add or remove lines. I also tried looking at things like sheet.pagesetup.printarea, but no luck. Is it possible to do something like: thisworkbook.printout() and use the print to file, to export the pages as a seperate workbook? Failing this, I shall go tell my client that it can't be done and blame excel. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Page (not a sheet) using VBA.
You can adapt the code in this example maybe
http://www.rondebruin.nl/hpagebreaks.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... Hi, Here's a tricky one... I want to be able to select a specific page in a workbook, and copy it to another workbook. For example: if sheet 1 prints out over 3 pages, I need the vba to select the second page of this. I can use VBA to select manually added pagebreaks, by referring to the vpagebreaks and hpagebreaks collections of the sheet, but this does NOT reference automatically added page breaks. This is probably because auto-pagebreaks have to be recalculated (re-paginated) every time you add or remove lines. I also tried looking at things like sheet.pagesetup.printarea, but no luck. Is it possible to do something like: thisworkbook.printout() and use the print to file, to export the pages as a seperate workbook? Failing this, I shall go tell my client that it can't be done and blame excel. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Page (not a sheet) using VBA.
Cheers Ron, that solves it.
In my initial testing I had assumed that hpagebreaks only included manually added breaks, not auto. But obviously that is not the case. Ron de Bruin wrote: You can adapt the code in this example maybe http://www.rondebruin.nl/hpagebreaks.htm -- Regards Ron de Bruin http://www.rondebruin.nl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Page Tabs | Excel Discussion (Misc queries) | |||
Page Setup not selecting | Excel Programming | |||
Selecting Text and deleting Page | Excel Programming | |||
Selecting all contents on page (range) | Excel Programming | |||
Selecting a Page in Page Break Preview | Excel Programming |