AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel-Windows Explorer, Vista, 7 Issue

 
Reply to topic    AutoHotkey Community Forum Index -> Ask for Help
View previous topic :: View next topic  
Author Message
Autohotkey Newbie user
Guest





PostPosted: Tue Mar 09, 2010 3:27 pm    Post subject: Excel-Windows Explorer, Vista, 7 Issue Reply with quote

Hi,

I have written a code that works under windows xp but it doesn't seem to work under windows 7 and Vista. I disabled UAC and everything.

I'm copy pasting information from Excel 2007 to Windows Explorer (web based database)

SO this is the problem, whenever I run the script once, it works. The second time i want to run it, the keyboard doesn't seem to be working properly.

When I left-click a cell, it goes automatically to the dictionary. When i click an icon, it goes to properties. and the keyboard seems to be asleep.

I have to switch user or log off in order to get the computer back to its normal state.

Has anyone encountered this problem? It has happened to me under Vista and 7.

Thank you!!
Back to top
doyle



Joined: 14 Nov 2007
Posts: 325
Location: London, England

PostPosted: Tue Mar 09, 2010 3:45 pm    Post subject: Reply with quote

Post your code.
Back to top
View user's profile Send private message Visit poster's website
Autohotkey Newbie user
Guest





PostPosted: Tue Mar 09, 2010 5:06 pm    Post subject: Re: Excel-Windows Explorer, Vista, 7 Issue Reply with quote

; well i used script recorder so I don't know if this will be easy to read or modify. I tried without winwait, pure mouse click recording/timing and got the same thing. After running the first time, i keep getting thesaurus for excel and keyboard falls asleep and my left click messes up.


#1::

WinWait, Microsoft Excel - Suspect DQ,
IfWinNotActive, Microsoft Excel - Suspect DQ, , WinActivate, Microsoft Excel - Suspect DQ,
WinWaitActive, Microsoft Excel - Suspect DQ,
MouseClick, left, 412, 10
Sleep, 1000
Send, {CTRLDOWN}c{CTRLUP}
WinWait, Microsoft Dynamics CRM - Internet Explorer ,
IfWinNotActive, Microsoft Dynamics CRM - Internet Explorer , , WinActivate, Microsoft Dynamics CRM - Internet Explorer ,
WinWaitActive, Microsoft Dynamics CRM - Internet Explorer ,
MouseClick, left, 669, 10
Sleep, 1000
MouseClick, left, 342, 217
MouseClick, left, 342, 217
Sleep, 100
MouseClick, left, 342, 217
Sleep, 1000
Send, {CTRLDOWN}v{CTRLUP}{ENTER}
WinWait, Microsoft Excel - Suspect DQ,
IfWinNotActive, Microsoft Excel - Suspect DQ, , WinActivate, Microsoft Excel - Suspect DQ,
WinWaitActive, Microsoft Excel - Suspect DQ,
MouseClick, left, 406, 13
Sleep, 1000
Send, {RIGHT}{CTRLDOWN}c{CTRLUP}{DOWN}{LEFT}
WinWait, Microsoft Dynamics CRM - Internet Explorer ,
IfWinNotActive, Microsoft Dynamics CRM - Internet Explorer , , WinActivate, Microsoft Dynamics CRM - Internet Explorer ,
WinWaitActive, Microsoft Dynamics CRM - Internet Explorer ,
MouseClick, left, 318, 289
MouseClick, left, 318, 289
Sleep, 1000
WinWait, Suspect: Information - Internet Explorer ,
IfWinNotActive, Suspect: Information - Internet Explorer , , WinActivate, Suspect: Information - Internet Explorer ,
WinWaitActive, Suspect: Information - Internet Explorer ,
MouseClick, left, 486, 124
Sleep, 1000
MouseClick, left, 543, 163
Sleep, 1000
WinWait, Confirm Assignment -- Webpage Dialog,
IfWinNotActive, Confirm Assignment -- Webpage Dialog, , WinActivate, Confirm Assignment -- Webpage Dialog,
WinWaitActive, Confirm Assignment -- Webpage Dialog,
Send, {TAB}{DOWN}{TAB}{CTRLDOWN}v{CTRLUP}{TAB}
MouseClick, left, 319, 259
Sleep, 4000
WinWait, Suspect: Information - Internet Explorer ,
IfWinNotActive, Suspect: Information - Internet Explorer , , WinActivate, Suspect: Information - Internet Explorer ,
WinWaitActive, Suspect: Information - Internet Explorer ,
Send, {ALTDOWN}s
WinWait, Microsoft Excel - Suspect DQ,
IfWinNotActive, Microsoft Excel - Suspect DQ, , WinActivate, Microsoft Excel - Suspect DQ,
WinWaitActive, Microsoft Excel - Suspect DQ,
MouseClick, left, 340, 21
Sleep, 1000

Return
Back to top
Display posts from previous:   
Reply to topic    AutoHotkey Community Forum Index -> Ask for Help All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group