![]() |
#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 | 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 |
![]() |
LadyAna | Word | 1 | 12-06-2014 10:39 PM |
![]() |
norwood | Word VBA | 2 | 02-03-2014 06:49 PM |