#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 Let me know if this helps at all of if you would like to go a different route. Thanks |
Tags |
macro |
|
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 |