<div>
I have some experience with modifying VBA code. What would be the best way with VBA code?
</div>


I have some experience with modifying VBA code. What would be the best way with VBA code?

<div>
If, for instance, all the files are in a single folder you can write a loop to loop through all the files in the folder, check their extension for a .xls or .xlsm, etc, open them, apply the page setup settings change, save and close them again.<br />
<br />
The only tricky part of this is getting the file location strings right, but that is generally not so hard. <br />
<br />
<a href="http://vbatutor.blogspot.com/2009/02/excel-vba-macro-example-opening-closing.html" rel="ugc">http://vbatutor.blogspot.com/2009/02/excel-vba-macro-example-opening-closing.html</a><br />
<br />
<a href="http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder" rel="ugc">http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder</a><br />
<br />
Those should get you started :)
</div>


If, for instance, all the files are in a single folder you can write a loop to loop through all the files in the folder, check their extension for a .xls or .xlsm, etc, open them, apply the page setup settings change, save and close them again.

The only tricky part of this is getting the file location strings right, but that is generally not so hard.

http://vbatutor.blogspot.com/2009/02/excel-vba-macro-example-opening-closing.html [http://vbatutor.blogspot.com/2009/02/excel-vba-macro-example-opening-closing.html]

http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder [http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder]

Those should get you started :)

<div>
<div class="content wysiwyg-content">
I have around 50 excel files and I want to change the page setup on all the files to have the same settings (Page margin, page orientation, column width, row width, etc). <br />
<br />
What would be the best way to change the page setup on all files without manually change each file at a time?
</div>
</div>


I have around 50 excel files and I want to change the page setup on all the files to have the same settings (Page margin, page orientation, column width, row width, etc). 

What would be the best way to change the page setup on all files without manually change each file at a time?

Apply page setup on multiple excel files

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.