Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 02-08-2010, 06:16 AM
Criterium Criterium is offline
Registered User
 
Join Date: 09 Oct 2008
Location: London
Posts: 7
Criterium is becoming part of the community
Correcting format error in multiple files

Please Register to Remove these Ads

I have 300 separate Word xml files, each containing a table of 8 columns of data and text. As a result of an error (not mine), the last column contains text in which the alignment is either Centred or Italicised when it should be Aligned left, Arial and 10 point size with no B, I or U applied. The table contains a variable number of rows from one file to another but between 8 and 12 rows and hence cells to be reformatted in the offending column. I can not reproduce the files correctly due to a S/W error.

I need to correct each file and save as a Word doc file (not xml).

I could open each file, reformat the offending column manually by hand and resave. I attempted to record a Macro, invoked by a keyboard button. But there seems to be no way to highlight the variable column length of cells automatically whilst recording the Macro. I do not have the knowledge to write a VB Macro.

Can anyone please suggest any way I might correct this large number of files and resave in the required format at Macro speed? The attached example shows what I have (Page 1) and what I want (Page 2). Any ideas would be much appreciated please.
Attached Files
File Type: doc Criterium Word file example.doc (89.5 KB, 1 views)

Last edited by Criterium; 02-23-2010 at 07:30 AM.
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Forum Jump