Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 12th, 2006, 11:04 AM
Friend of Wrox
Join Date: Jan 2005
Posts: 100
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transfer Page Setup Properties

Hi all,

I am automating the creation of some reports and would like to transfer the page setup properties of one report to another. Does anyone know of an easy way to do this. I was thinking of something like

For Each property in wksSource.pagesetup
    wksDestination.pagesetup.property = property
Next property

Any ideas???


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print a page without changing page setup nrajeshatwork Servlets 1 May 23rd, 2007 10:09 AM
transfer a DataTable from one Page to another ratheesh_param ASP.NET 2.0 Professional 1 November 30th, 2006 05:58 AM
Transfer Values from one page to another page saravananedu ASP.NET 1.0 and 1.1 Basics 6 August 17th, 2005 12:03 AM
Transfer to another page in same Application rastvan ASP.NET 1.0 and 1.1 Professional 1 February 13th, 2005 06:35 AM
Page setup thutt Access 1 June 17th, 2003 07:50 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.