Absolution
New Member
- Joined
- Feb 7, 2005
- Messages
- 27
Hello all. Hopefully some of you gurus out there can help me in my current venture.
What I am wanting to do is write a script which will tell Excel to go into a html file, search for specific values, and then return a portion of the data based on what it finds in the document.
I have no code yet as I am trying to find a start point. I can probably get the rest of the code to do the searching and copying (I Hope) but my stumbling block is the first hurdle of how I am going to tell Excel to get this data.
Two points to mention.
1. The files have different names and I would rather just be able to save them to a specific directory and set the thing running on a few of them, but am prepared to do it the slightly longer way around if needs must, by either saving them as a different name, or having the file open when I run the event.
2. The files have the same format, so once I have the starting point, the code should be the same in all cases and I can find the information via keywords.
If anyone has any tips or comments they feel would be useful to me in this task, please feel free to speak your mind as I appreciate all the help I can get.
What I am wanting to do is write a script which will tell Excel to go into a html file, search for specific values, and then return a portion of the data based on what it finds in the document.
I have no code yet as I am trying to find a start point. I can probably get the rest of the code to do the searching and copying (I Hope) but my stumbling block is the first hurdle of how I am going to tell Excel to get this data.
Two points to mention.
1. The files have different names and I would rather just be able to save them to a specific directory and set the thing running on a few of them, but am prepared to do it the slightly longer way around if needs must, by either saving them as a different name, or having the file open when I run the event.
2. The files have the same format, so once I have the starting point, the code should be the same in all cases and I can find the information via keywords.
If anyone has any tips or comments they feel would be useful to me in this task, please feel free to speak your mind as I appreciate all the help I can get.