![]() |
|
#1
|
|||
|
|||
|
Hello all,
I'm new to Word macro. A Word expert has supported me to automate capturing specific contents from word to excel. Now, I need some little more modification with mentioned macro file. Can someone guide to explain below word macros please? It will make easier to modify based on my requirement .Text = "Declaration*NIC*^13*[^12^13]{1,}" - What does ^13*[^12^13]{1,} means? .Text = "[ ]{1,}[OI][rn][id][gi][ia][[n]*Inv No & Dt.*^13" - What does [ ]{1,}[OI][rn][id][gi][ia][[n]? .Text = "([0-9]{1,})[!^13]@| ([A-Z0-9]@>)*([0-9.]{4,5} %)*([0-9.]{4,5} %)*([0-9.]{4,5} %)*^13" - How it works? Above macro used to pull part numbers, what if there is a symbol mentioned in part number or like this PK_2314K16 ? Will it capture it Also, need understanding if it meant for one row or can be used for two rows of specific data like this 173 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS) | 1068715 .Replacement.Text = "\1^t\2^t\3^t\4^t\5^p" - What does it mean? |
| Tags |
| word macro |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to transfer data from Word to another Word document with bookmark | Jovan Yong | Word VBA | 3 | 04-17-2018 04:27 AM |
| macro error message - interpretation | H28Sailor | Excel Programming | 3 | 03-03-2017 07:37 AM |
| Macro to put 1 word of a MS Word file in 1 cell of a Word or Excel Table | Singh_Edm | Word VBA | 6 | 11-13-2015 08:48 PM |
Macro Question: Need help making a macro to highlight the first word in every sentence
|
LadyAna | Word | 1 | 12-06-2014 10:39 PM |
Word 2003 Macro problem running in Word 2010
|
norwood | Word VBA | 2 | 02-03-2014 06:49 PM |