Search results for query: *

Macropod, I took your code and added the "login" code, tweaked on it a bit, and it worked excellently. I had no knowledge of the Regular Expression object, and i am glad you showed that to me. This was exactly what i needed and now my problem is solved. Thanks for your help.

Macropod, I guess you didn't see the post where I said "Just after I posted this, i found a way to go straight to excel with this code". Whenever I was exporting the source code into excel, before, some other software i use would not open it using excel. In order for what i am trying to do...

Actually, I liked that code you posted. I like the way you think. Problem is, that code willl nto work for me, because the website I am getting the source code from requires a login. I am using another program to login and extract the code to excel. I am still having trouble even though I got...

Just after I posted this, i found a way to go straight to excel with this code. I am more experienced with excel VB commands, so I should be able to figure this one out. I do not know how to delete the post, so i guess it will just stay up. Although, if anyone has any suggestions, I will take...

I'm not sure how to delete this post, but I started a new one in the correct forum. This one is obsolete now.

I need to write a macro in Word to find and copy some text. The text that I need to find is a URL in the source code from my company's website. The problem is that the URL changes everyday because it includes a time range. I found that in the source code, just two lines below the URL that I...

I need to write a macro in Word to find and copy some text. The text that I need to find is a URL in the source code from my company's website. The problem is that the URL changes everyday because it includes a time range. I found that in the source code, just two lines below the URL that I...

This issue is solved.

It works!! I owe it all to you, Geates. I had to changed two things about the code to get it work the way I needed it to. 1. I had to make it create the email object first. 2. I told it to attach any valid file as it ran through the files in the folder, as oppose to after it was finished...

...Set objOutl = CreateObject("Outlook.Application") Set objMailItem = objOutl.CreateItem(olMailItem) objMailItem.Display strEmailAddr = "mike@*********.com"; "john@********.com"; "xeeq@*******.com" objMailItem.Recipients.Add strEmailAddr objMailItem.Body = "Hey, how's it going?"...

I have appreciated your help thus far, but obviously you are getting frustrated. First of all, I have told you more than once during this thread that I am no programmer. I also stated that I first started working with VBscript ONE WEEK before I posted this thread, and that I researched arrays...

How do I do that? I don't know how to write code to get it to return something. I would want it to return any file that has yesterdays date. I added the rest of the code that you wrote, but took out all lines that had anything to do with client name. I the told it to attach "arr attachment". Now...

...strEmailAddr objMailItem.Body = "Stuff" objMailItem.Subject = "Howdy" objMailItem.Cc = "More email addresses" strAttachment = ****I JUST NEED TO KNOW WHAT TO PUT HERE**** objMailItem.Attachments.Add strAttachment Set objMailItem = nothing Set objOutl = nothing I don't know how to reference...

You were exactly right and that code made it valid, but it still says NOT valid in the first message box we were using. I have a question (and this could possibly make things much more simple). Is there a way to tell VBS to attach anything that is "Valid" for "GetYesterday" to the message...

Sorry for the pause in activity, I had a heavy load last week. Ok, so I ran the message box function through and it gives me a message box with Oct-30 Oct-30.pdf Then another with the "is NOT valid" message that I love so much. The bottom file in that message box is the file that it found...

I see how that could be a problem. Ok, I changed the test file name to match the format "name-month-day.pdf", and when we add a variable word to the file name we will just put a dash before the variable so it will look like this "name-month-day-var.pdf" Therefor, VBS won't care about the...

Wow, that took me forever, but I have some advancements. I had all kinds of problems. First off, I had the "objFSO.GetFolder" set in a fold with no files in it. I corrected that, then realized all of my attachment file names are separated by dashes and not underscores. I fixed that, but...

Ok, I just got past the array problem I was having. The good news is, the code returns no errors when I run it. The bad news is, it does nothing at all when I run it. I will post the finalized code, but understand for privacy, I had to change client names to "Client" and asset names to...

Please keep in mind, and like I said earlier, I just started working with VB Script about a week before this thread, so I only know the very basics of how this all works. I do not know how to give the an array values. I have read up on arrays and looked at codes for various arrays, but I...

Now I am getting "Subscript out of range 'ubound'" at this section for j = 1 to ubound(arrAttachments) objEmail.AddAttachment(arrAttachments(j)) next The only knowledge is knowing that you know nothing.