Transfer Page Setup Properties

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Transfer Page Setup Properties

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

January 12th, 2006, 11:04 AM

JpJoe

Friend of Wrox

Join Date: Jan 2005

Posts: 100

Thanks: 0

Thanked 0 Times in 0 Posts

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

Jon

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