Search found 10 matches

by philmcmannis
Tue Mar 25, 2008 5:25 pm
Forum: Technical / Scripting
Topic: Excel Cannot Empty Clipboard
Replies: 0
Views: 3218

Excel Cannot Empty Clipboard

I've done some searching and despite finding lots of info I have not found anything relevant to my issue. I am running a macro that copies text out of a cell in Excel and then pastes it into Internet Explorer. Randomly I will get an error message after sending Ctrl+C in Excel that says "Cannot Empty...
by philmcmannis
Thu Jul 26, 2007 2:23 pm
Forum: Technical / Scripting
Topic: Auto Logon Not Working
Replies: 2
Views: 4148

I should add that the user name is pre-populated when trying to unlock and Macro Scheduler is making no attempt to change this. ( I tried putting in a wrong username in the auto logon settings and it did not change the name when trying to unlock.
________
Ipad guide
by philmcmannis
Thu Jul 26, 2007 2:19 pm
Forum: Technical / Scripting
Topic: Auto Logon Not Working
Replies: 2
Views: 4148

Auto Logon Not Working

Hello By group policy my CPU locks every 15 minutes. I have tried to use the auto logon setting to run a macro after locking but it does not work. The Ctrl Alt Del command goes through when it tried to lock, but Macro Scheduler does not input the password I have supplied. I am running XP SP 2 in a c...
by philmcmannis
Wed Jul 11, 2007 1:07 pm
Forum: Technical / Scripting
Topic: What if Scheduled Macros Overlap?
Replies: 1
Views: 3211

What if Scheduled Macros Overlap?

Hi I was wondering what will happen if scheduled macros overlap? I have macros setup to run on a regular basis. Each macro has some error checking code in them so that if an error occurs, the macro pauses with a modal message I can fix whatever didn't go right and then let the macro continue. If one...
by philmcmannis
Thu Jun 28, 2007 7:38 pm
Forum: Technical / Scripting
Topic: Use SMTPSendMail with Gmail
Replies: 5
Views: 8700

I have authentication setup. Current code is below. Result Unable to connect to server Let>SENDMAIL_STATUS=1 Let>SMTP_AUTH=1 Let>SMTP_USERID=user@gmail.com Let>SMTP_PASSWORD=password Let>SMTP_PORT=465 SMTPSendMail>Recipients,smtp.gmail.com,email,Name,Subject,Body, Message>%SMTP_RESULT% ________ Volc...
by philmcmannis
Thu Jun 28, 2007 7:15 pm
Forum: Technical / Scripting
Topic: Use SMTPSendMail with Gmail
Replies: 5
Views: 8700

Use SMTPSendMail with Gmail

Is it possible to use SMTPSendMail with Gmail. I have my gmail account turned on to utilize SMTP but the command doesn't seem to be working. I'm going to go on a limb and assume it's because SMTPSendMail doesn't use SSL or something like that. Anyone have experience with this? Thanks ________ Honda ...
by philmcmannis
Tue Jun 26, 2007 7:15 pm
Forum: Technical / Scripting
Topic: Using string in if Function
Replies: 13
Views: 11955

I've got it going now. Used to stringreplace as spaces don't have an effect on what I'm trying to do.

Thanks!!
________
Robert lutz
by philmcmannis
Tue Jun 26, 2007 4:42 pm
Forum: Technical / Scripting
Topic: Using string in if Function
Replies: 13
Views: 11955

I just tried inserting the code you wrote after grabbing the text from excel. What I put in is: VBEval>Replace("%RecordCount%",chr(13),""),RecordCount VBEval>Replace("%RecordCount%",chr(10),""),RecordCount VBEval>Trim("%RecordCount%"),RecordCount I'm getting an error that says Microsoft VBScript com...
by philmcmannis
Tue Jun 26, 2007 4:04 pm
Forum: Technical / Scripting
Topic: Using string in if Function
Replies: 13
Views: 11955

Thanks for the quick response. My IF statement is working correctly which means this is actually related to what I'm trying to copy out of Excel. What I'm trying to do is Copy a cell in Excel, Store that text as a variable and then evaluate that variable with an if command. I've used messagemodal to...
by philmcmannis
Tue Jun 26, 2007 3:19 pm
Forum: Technical / Scripting
Topic: Using string in if Function
Replies: 13
Views: 11955

Using string in if Function

Hi I'm trying to use a string variable I have stored in and IF statement and I can't get it to work. The code I'm using is The have set the Country variable using the Getclipboard command. I know the variable is storing correctly as I've used messagemodal to pull it up and it is storing Canada If>%C...
Sign up to our newsletter for free automation tips, tricks & discounts