ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need macro to updated column C's width on 1000+ workbooks. (https://www.excelbanter.com/excel-programming/336290-need-macro-updated-column-cs-width-1000-workbooks.html)

ChatsworthWL

Need macro to updated column C's width on 1000+ workbooks.
 

I need help and guidance.

I need to resize one column, the same column in every workbook ($C), in
a couple thousand workbooks. I was able to create a macro that will
resize the column and save the changes but I do not know how to execute
it on all workbooks in a certain directory.

Please help.


--
ChatsworthWL
------------------------------------------------------------------------
ChatsworthWL's Profile: http://www.excelforum.com/member.php...o&userid=25882
View this thread: http://www.excelforum.com/showthread...hreadid=392639



All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com