|
|
|
|
#1
06-03-2025, 03:59 AM
|
||||
|
||||
Simply delete your existing FormatRows sub, then copy & paste the FormatRows sub from post #36 into your existing code module.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
#2
06-03-2025, 04:15 AM
|
|||
|
|||
|
it worked, many thanks Paul
appreciate your help have a good day
|
|
#3
06-03-2025, 06:13 AM
|
|||
|
|||
|
sorry, just double checked, the macro is replacing spaces in the file name for dots in the caption
|
|
#4
06-03-2025, 03:53 PM
|
|||
|
|||
|
following your advice I replaced the periods with dashes in the file name and this did not change anything, spaces are still shown as periods in the caption
|
|
#5
06-03-2025, 04:16 PM
|
||||
|
||||
|
The macro can't do that, since there's no code in it to do so. I suspect you either didn't change all the filenames or you ran the macro against the wrong set of files.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
#6
06-03-2025, 04:44 PM
|
|||
|
|||
|
my mistake, ran it again and its perfect
I had paragraph marks showing which confused me many thanks
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro for Inserting Multiple Photos from Excel List into Word
|
henhelm | Word VBA | 15 | 02-07-2023 05:35 PM |
|
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet
|
macaronipasta | Word VBA | 2 | 06-27-2021 06:28 PM |
|
I need a macro to automatically insert 4 pics per page in a word document with "Photograph No 1, 2,"
|
NewbieLearning | Word VBA | 15 | 11-14-2017 05:03 AM |
|
Captions: Changing captions in Appendix update all captions
|
carnestw | Word | 3 | 10-27-2015 12:34 PM |
| How do I type on multiple pics? | TimHudson | Drawing and Graphics | 0 | 07-28-2011 10:28 AM |
Windows 10 
Office 2016
Hybrid Mode