|
|
#12
03-28-2013, 11:50 AM
|
|||
|
|||
Hi Paul,
Sorry I was away for so long, I was working on another project and also started school recently. When I run the code above I get a "subscript out of range" error for the same line of code as before: Code:
StrTxt = Format(Trim(Split(.Text, "-")(0)), "MMMM D, YYYY")  -Donna Is it possible that changing a reference in Access would affect MS Word?? I added a ref to Microsoft ActiveX Data Objects 2.5 Library for a module. Could that be the problem? 
|
| Tags |
| excel 2007, find and replace, vba in microsoft word |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
 Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
|
Is there a way to use "find/replace" to find italics words?
|
slayda | Word | 3 | 09-14-2011 02:16 PM |
|
Help with find and replace or query and replace
|
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
| Find and Replace within range | anil3b2 | Word VBA | 3 | 12-01-2010 02:35 AM |
Windows 7 64bit 
Office 2007
Threaded Mode