Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 29th, 2007, 04:32 PM
Registered User
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA-API form filler for external application

Hi Guys,

I'm new to this forum but I have intermediate knowledge of VBA.


I have a form that I would like to fill-out from excel. I get the data already in xls and I have to retype everything into this form. It's only once a month but it's a worst day of the month for me. I call this the opposite of work smart.

It's a none MS application which inputs data into networked dB. Because it's at work I can't just import data into it (limited access, won't be allowed) nor I can get our IT staff to create an import function. Also, the form checks the data and creates some reference numbers.

I was thinking if I can get excel to type or paste the data from the cells to the fields on the form and then tab on the form as it moves to the next cell. I know it sounds like going back to stone ages with the technology we have right now but this is the only way for me.

What are your thoughts guys. I would greatly appreciate if you can point me to the right direction.

Many thanks,
Dmitri
 
Old January 30th, 2007, 04:28 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Dmitri,

If its a non-MS app then I'm guessing that it doesn't expose an object model to allow you to automate it? Casting that option aside the only sensible suggestion I can come up with is to use SendKeys to imitate key presses and the manual input of data. You're right this is stone age technology and is prone to not working but it sounds like the best you can do.

Maccas






Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows API - Can I find the Active Application?? MAtkins Pro VB 6 3 August 23rd, 2013 06:10 AM
please help, how to load external application hard boiled Beginning VB 6 3 June 11th, 2007 03:47 PM
Porting C++ winsock API application to ATL wambozi Visual C++ 1 September 11th, 2006 10:16 AM
VBA API karen999 Excel VBA 4 August 25th, 2005 10:13 AM
VBA programming of "Get External Data" John Hollingsworth Excel VBA 2 August 2nd, 2005 10:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.