View Single Post
 
Old 05-21-2015, 10:05 PM
excelledsoftware excelledsoftware is offline Windows 8 Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Ok to get you started I have included a script that will fill in Wunderlist with a list of tasks.

Code:
Sub WunderlistImporter()
 
	AppActivate ("WunderList")
	 
	For x = 1 To 7
		SendKeys "^n", True 'activates a new line via program keyboard shortcut
		DoEvents
		SendKeys (Range("D" & x).Value)
		DoEvents
		SendKeys ("{ENTER}")
		DoEvents
	Next x
	
	AppActivate("Excel")
	End
	'If you experience issues with numlock use this comment out End
	'Put numlock back
	SendKeys ("{NUMLOCK}"), True
	 
	'shoud put in ten tests
	'AppActivate ("Excel")
 
 
End Sub
Now with sendkeys you can run into BIG problems. There may be a way to make a shell object of the program that you are using but it is not something that I have a lot of experience with. You may decide to play around with SendKeys and see if between tab and loops you can enter the data you need.

Let me know if this helps at all of if you would like to go a different route.

Thanks
Reply With Quote