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

saurabhlotankar · #1 05-20-2015, 01:45 AM

Hi Everyone,

I work for an MNC and we use one compnay designed application to fill up few details. There are few text boxes, few drop downs designed in it. Once data is filled up we export reports from it in excel format.
I want to design a macro through which i can open that application/software, login to it and fill up required information. i want a code for opening such application.

Thanks.

excelledsoftware · #2 05-20-2015, 10:47 PM

Is this application web based? if so you could just manipulate IE to do it. If it is another application you might be stuck using winactivate and sendkeys. I wrote a wunderlist importer that will import an Excel list into it. Let me know what kind of app it is and maybe we can make something that will work.

saurabhlotankar · #3 05-21-2015, 01:00 AM

First of all thank you so much for your time.

Its not a web based application. We have .exe file saved on our local drive. everyday we launch that by double clicking and start filling up required data as per our requirement in different drop downs and text boxes.

I am completely new to this. So if you any such code which you might have created by any such application then you can show it to me. I will try and design first cut looking at it and share it with you. Accordingly we can go ahead.

Thanks in advance.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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