Macro to open and fill up data in an application on local drive

excelledsoftware · #4 05-21-2015, 10:05 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM
copy data from outlook attached excel file into a local one	s_samira_21	Outlook	4	09-17-2014 11:46 PM
excel 2013 local file contact to shared path when i open it	osama6767	Excel	3	05-28-2014 06:29 AM
Saving Emails to my Local Hard Drive	MichaelWaite	Outlook	1	02-08-2012 06:53 AM
Can't open documents directly from a shared drive	MikeJedi	Word	0	12-08-2009 12:04 PM