Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set default column width for all new workbooks? CW Excel Discussion (Misc queries) 6 August 8th 07 11:22 AM
Default Row Height & column width Settings for new workbooks robbroy Excel Discussion (Misc queries) 2 March 8th 07 03:27 PM
Macro for column width Martincito23 Excel Discussion (Misc queries) 4 January 10th 07 04:07 PM
Macro to Keep Linked Workbooks Updated Karl Burrows Excel Programming 0 January 15th 04 05:59 AM
Getting Column width using macro.. KM[_2_] Excel Programming 3 November 7th 03 10:08 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"