I'm glad you see you guys have provided work arounds :P I'll have to give these a shot. Hopefully Marcus can just put in a nice little length limiter so we won't have to write the extra code. I know he was talking about making small changes to the Dialog Designer in another forum. I understand its n...

I've went ahead and enabled the disabled button. It works nicely :) So far I've gotten the script to do everything I need it to do. I was having some weird issues with the SMTPSendMail command though. For some reason it wouldn't send the message with an attachment until I modified the line to read t...

In the Dialog box designer if you add a text box for input it's possible to put as many values as you want in there. It'd be nice to at least have a check box when your creating the text box object to be able to specify a length that the user can input into the box. Thus preventing users from trying...

I have a feeling I'll have to make changes in my MainLoop section in order for it to do an IF ELSE test on which button is clicked first.

Awesome Thanks for the info Marcus. I got it working :) Now last question! I have it set up in a dialog where Button 1 generates the report and button 2 emails the report as soon as I'm done editing it, finally its sent via SMTP as an attached excel document How Do I make sure button 2 isn't clicked...

Is this specific GetTextAtPoint feature only in 10+?

Ok I just tested DDE Poke and it's definitely inserting stuff back into excel so I'll use this command to get data back into the spreadsheet with the corresponding ticket number. I'm assuming I'll do something along the lines of. Grab C1, R2 from excel sheet, go back to the program and input that in...

Also I'm unaware of how to use the DDEPoke command. I'm presuming this allows you to import data back into excel?

Thanks for the great program so far I'm just trying to figure out this out in my head. Basically I have the macro locking onto a program at my work. The program connects to a MYSQL database. Inside the program it can generate a report of all open ticket issues via an excel spreadsheet. I have it gen...