Thanks JRL... I figured out what you meant shortly after posting ... however, what if i want it to loop as much as 5 times. As I stated above... the file will always have at least 1 URL and up to 5 URLs - BUT NEVER MORE. Am I still Okay with your repeat settings?? If not how do I mod to include a po...

Ok... I was browsing and found this topic... but you stopped just short of answering my question.. How did you pass the content of the variable to the dialogue.. in this specific case the combobox????? Anyone? Thx to all who read my question. In time i got it solved with a easy readfile command. Rea...

This is worth a try... i actually need it to list as many as 5 urlsl. There will never be less than 1 url and never more than 5. Using your suggestion below however I'm not sure I understand because the Let>k=k+1 is already at the fine line underneath the repeat. I have an idea. Start with let>k=0 a...

OK. I had screwed up specifying the source file to read from... my bad... now it works... HOWEVER, when we get to the separate part of the code below it seems to be dropping one of the four URLs created in the VBEval "regex" step (full script above). I know there are 4 Urls cause I did a message> on...

I still get the following error even after making the suggested change below. And I was carefule to replace c:\urls.txt with my actual path to my file "Microsoft VBScript runtime error :5 Invalid procedure call or argument: 'Mid' line 13, Column 2 " replace line 37 - WriteLn>outputfile,result,ThisUR...

I've specified the path to my file d:\mytextfile.xml and it still gives the error. Does it matter that it's an xml file versus text file? That's exactly the error I get if I don't supply a data file. Try replacing the " yourfile " in the line: ReadFile> YourFile.txt , FileData with the path and file...

I created a empty script file in Macro Scheduler and pasted in your code and got the following error when I clicked run: "Microsoft VBScript runtime error :5 Invalid procedure call or argument: 'Mid' line 13, Column 2 " Something like this: //A VBScript Function to search a string for a regex patter...

Thanks! I will try this and let you know the results!

Hi, I have what seems to be a simple requirement, but I'm beyond my knowledge in how to script it. Here's what I'm trying to do: 1. Read all contents of a text file and put it into variable "xmlText" 2. Perform a search within variable "xmlText" using regular expression pattern to filter out only se...

I try to paste the xml code using the 'code' function but it hasn't worked yet... keeps stripping all the URLs which renders it useless as a referrence Okay... i've narrowed down my requirement to need a regular expression written which I can then code into VB I want to search an XML file or Text fi...

So am I to assume this forum doesn't have the expertise? I mean I just bit hook line and sinker and payed a couple hundred bucks for Macro Pro and I can't even get a response?? Anyone? If you an take this headache off me... and solve this problem I'd even be willing to pay someone modestly to do thi...

I think his question about .CSV/Excel was answered... but WHAT ABOUT XML??? That was the other part of his initial question above??


Anyone have any ideas?

HEEEELLLLLLLLPPPPPP!!!!!! I have an XML file I need to parse using Macro Script. I want to extract specific urls located in a particular section of an XML file and copy them into a designtated text file. Iam New to Automation and programming...and this has been tricky and the forum has been of some ...