Hey guys. Been a while since I couldn't find an answer already listed in the forums but I have searched this time and can't seem to find an answer. Feel free to advise a better way of going about this as well. Always open to suggestions. What I need to do is sum all the unique values of an excel fil...

Ahh, thanks for the input. I have a testing database setup that I can use to perform keyed input tests. The reason I am trying to do it with direct communication with the database is because we have been having random issues out of one of the order entry scripts. runs fine most of the time but there...

I have been using Macro Scheduler for a number of tasks around the office over the last few months but now I am attempting to do something a bit more complex than just computer control at a local machine. I am attempting to connect to our database to speed order entry with out having to tab through ...

JRL! Thats exactly what I was trying to do yesterday with this code. I could not for the life of me figure out hot to calculate the math with the round function. I tried looking through the help file for how to use it but was not successful. Thanks for explaining it. I bet this will work exactly for...

Thanks for the help guys. When I first tried this it worked like a champ. However now I am trying to use it today and its giving me a "vbscript runtimes are not properly installed". I have tried un-installing macro scheduler and the restarting and reinstalling to no avail. I also tried installing fr...

This worked! Thanks very much.

One question though, why is the code for doing the function not contained within the vbstart and vbend commands?

Sorry, Showing my ignorance and inexperience here.

I am trying to change a variable so that it only displays a maximum of 7 decimal places in a variable. as stands right now there are 13+ decimal places showing. I know I can count the number of digits in the string but if there are more or less numbers before the decimal places that will change how ...

Okay I will double check the screen color depth and see if I can fix that. How do I go about re capturing the images on that machine without installing Macro scheduler on that machine? I only have one license for the software.

I have a script that I have been working on for about the last week or so. It uses several instances of image recognition and work fine on my machine. I have the pro version because I will need to be able to run the scripts I create on other machines. - I exported the exe, and saved it to the server...

I am trying to use the below script to delete a bunch of un-needed columns from an excel file. Wondered if anyone could help me find what is wrong in this code. Right now it just sits the and loops. It should stop deleteing columns at row 66 starting at 26. I have tried the until command with and wi...

wow, that looks like it just might work. Thank you soooooo much. this is going to be very helpful I think. I am going to mess around with this and see what I can come up with. Thanks for this input! This forum is great!

I just used GetWindowText and GetWindowTextEx and was able to retrieve a lot of text from the search window that displays the results of a customer search however it doesn't find any of the customer names. Just the Text on all the buttons and tabs and what not. So thats a no go it seems. I guess tha...

thanks for the input. I would love to be able to communicate directly with the database. I am about the best you will get for knowing the database but thats not much. LOL I am the IT director and took over for someone who also didn't know much about epicor. I do know it is a progress database that i...

thanks for the reply. however I already have the excel functions worked out. I am able to draw out the information from the spread sheet. I have each one assigned to a variable that I need. What I need to do it capture whats on screen (guessing to a JPG or BMP) then search the screen for a spacific ...

Hi there. First time poster. I am new to MS but not new to scripting. Have done a bunch of VB scripting in excel and some limited programming. I am hoping its possible to do what I need to do with MS Pro. I just purchased a few days ago. Basically I have an Excel file containing customer contact and...