Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2015, 01:45 AM
saurabhlotankar saurabhlotankar is offline Macro to open and fill up data in an application on local drive Windows XP Macro to open and fill up data in an application on local drive Office 2010 32bit
Novice
Macro to open and fill up data in an application on local drive
 
Join Date: May 2015
Posts: 29
saurabhlotankar is on a distinguished road
Default Macro to open and fill up data in an application on local drive

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.
Reply With Quote
  #2  
Old 05-20-2015, 10:47 PM
excelledsoftware excelledsoftware is offline Macro to open and fill up data in an application on local drive Windows 8 Macro to open and fill up data in an application on local drive Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 05-21-2015, 01:00 AM
saurabhlotankar saurabhlotankar is offline Macro to open and fill up data in an application on local drive Windows XP Macro to open and fill up data in an application on local drive Office 2010 32bit
Novice
Macro to open and fill up data in an application on local drive
 
Join Date: May 2015
Posts: 29
saurabhlotankar is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 05-21-2015, 10:05 PM
excelledsoftware excelledsoftware is offline Macro to open and fill up data in an application on local drive Windows 8 Macro to open and fill up data in an application on local drive Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
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
Reply

Tags
macro

Thread Tools
Display Modes


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
Macro to open and fill up data in an application on local drive 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft