-
It's a standard form with a lot of word cells, without patterns. There are about 20 cells and different information.
I can copy all the form and paste without format.
I understood Graham code, but i'm newbie in VBA and need now to understand how to extract string between two expressions.
My current difficult yet is extract the name. I don't want to use MoveEndUntil to do this, because It will not be enough to extract adress, for exemple - because if I put "Do While .Execute("address:"): orng.Collapse 0: orng.MoveEndUntil "4"" and the address has a number 4, it will be a problem.
After paste, without format, it's similar to this. It's not the real form, but it has the same method used in the real form.
I – PERSONAL INFORMATION:
1. Full name:
2. ID: 3. SOCIAL INSURANCE NUMBER:
4. Address: 4.1.Zip code:
5. E-mail: 6. Phone number:
7. Graduate:
8. Previous job: ()
8.1. Company name:
II – DO YOU WANT TO ANSWER PROFISSIONAL REQUESTS? ( ) YES ( ) NO
10. Is this your first job? ( ) YES ( ) NO
Inform the date you started working: _____ /_____ / _____
III – INFORMATION ABOUT HEALTH
11. Type of previus disease:
( ) headache;
( ) bellyache;
( ) elbow;
( ) another.
11.1. Describe syntoms:
_________________________________________________________________________
11.2. Name of hospital:
_________________________________________________________________________ 11.3. Period:
Date of sytoms started
_____ /_____ / _____
Date of syntonms end
_____ /_____ / _____
Last edited by Wandem; 04-11-2020 at 04:58 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules