![]() |
|
#15
|
|||
|
|||
|
thank you for the latest instructions
the result was a colon prefix and dots instead of spaces which I have been able to remove by replacing this StrTxt = Split(.SelectedItems(j), "")(UBound(Split(.SelectedItems(j), ""))) StrTxt = ": " & Left(StrTxt, InStrRev(StrTxt, ".")) with this StrTxt = Split(.SelectedItems(j), "")(UBound(Split(.SelectedItems(j), ""))) StrTxt = Left(StrTxt, InStrRev(StrTxt, ".")) but its still producing a dot as a suffix at the end of the caption also the caption is showing bottom row while it should be position on the top I cannot attach an image |
|
|
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 |