JRL,

Thank you very much. It's works great. I've been trying to figure this out for quite a while and couldn't do it. Would you mind explaining why the quotes "" are needed. BTW as you probably know I found your Date Mask on the forum search and it is fantastic!!. Thanks again for the help

CZ

Hello, I'm trying to get a week day name for dates. I've searched the forums for the answer, but can't seem to get it. Whenever I run the macro I get "7, Saturday" no matter what date I enter. I would appreciate any help. Here is my code: //Set IGNORESPACES to 1 to force script interpreter to ignore...

Hello, Thanks again for your reply. I am not running over a remote desktop/VNC type connection. I finally figured out what the problem was. For whatever reason my Display Settings must have been out of whack. I have it at its default of 125%. So I went down to 100% and the image recognition worked p...

Hello, Thank you for getting back to me. Sorry the file name was 7 Site_1.bmp file that I was referring to. I had named the image "7 Site" when I was capturing the image and it automatically saved to 7 Site_1.bmp. So I was using the correct file. Not sure why but when I try to attach the 7 Site_1.bm...

Hello I am trying to have the mouse click on an item on a web page, however when I activate the code I entered for the macro the mouse moves close to the area of the item, but not right on the item itself. Not sure what I am doing wrong. I used the Image Recognition Wizard to capture the item and th...

Hi hagchr, Wanted to let you know that I finally figured out what you were trying to say about changing the date format. I was thinking that you were talking about changing the date format in the Excel program itself. I finally noticed that the date format on my computer was MM/dd/yyyy. When I chang...

Thanks again for the reply, but unfortunately it didn't work. It does go to the correct worksheet, but it doesn't go to the date. I tried changing the dates so that they are like 9/1/14 instead of 09/01/14, but that didn't help. I did notice however that if I do a search in the spreadsheet itself (C...

Hi Thank you for your reply. I tried it, but it doesn't work. It seems that if I take out the "oExcel.Range("C2:XDF1000").Select" line in the code the Workbook won't automatically go to that Worksheet that has the dates in it. Also I keep getting the msgbox "Not Found" when I know that today's date ...

Hello everyone Been trying to figure out how to find today's date in a cell in an Excel Worksheet and have that cell selected. I've done some research and I'm still thoroughly confused. The only thing that I'm pretty certain of is that I would have to use VBScript. I am not very good with it though....

Thank you for that quick reply. It works great. Thanks again.

Hello I am trying to manipulate a string in a cell in Excell so that I can select the first portion of the string in Excel before the word "by" and then paste it into another cell and then select the second portion after the word "by" and put it in another cell in Excel. Here is an example, in this ...

Thank You for your quick response. I'll try that.

Hello I am new to using the Macro Scheduler 9.0 I had used the evaluation version and have just gotten the Pro version. This is a very good program, but I am very new to scripting and programming. I have been trying to figure out how to do this for a while. I have looked at all the forums and help f...

Thanks for the help. Really appreciate it. It works great.

I really appreciate the replies that I got on my last post. I was wondering if there was any way to create a message box on how long a macro that is currently running takes from start to finish. Also I thought that I had read something about a Delay function or code in the forum that refers to not h...